Script to compute randon page cost - Mailing list pgsql-hackers

From Hans-Jürgen Schönig
Subject Script to compute randon page cost
Date
Msg-id 3D7C567B.20006@cybertec.at
Whole thread Raw
Responses Re: Script to compute randon page cost  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
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>



pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: PREPARE code notes
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Script to compute randon page cost