Assuming it's giving out correct information, there seems to be a lot of evidence for dropping the default random_page_cost to 1...
Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Hans-Jürgen > Schönig > Sent: Monday, 9 September 2002 4:06 PM > To: pgsql-hackers > Subject: [HACKERS] Script to compute randon page cost > > > Linux RedHat 7.3 (ext3, kernel 2.4.18-3) > 512MB Ram > AMD Athlon 500 > IBM 120GB IDE > > > [hs@backup hs]$ ./randcost.sh /data/db/ > Collecting sizing information ... > Running random access timing test ... > Running sequential access timing test ... > > random_page_cost = 0.901961 > > > > [hs@backup hs]$ ./randcost.sh /data/db/ > Collecting sizing information ... > Running random access timing test ... > Running sequential access timing test ... > > random_page_cost = 0.901961 > > > Great script - it should be in contrib. > > Hans > > > > -- > *Cybertec Geschwinde u Schoenig* > Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria > Tel: +43/1/913 68 09; +43/664/233 90 75 > www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at > <http://cluster.postgresql.at>, www.cybertec.at > <http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at> > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster