Re: Script to compute random page cost - Mailing list pgsql-hackers

From Hans-Jürgen Schönig
Subject Re: Script to compute random page cost
Date
Msg-id 3D7EF704.3000609@cybertec.at
Whole thread Raw
In response to Re: Script to compute random page cost  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
AMD Athlon 500
512MB Ram
IBM 120GB IDE

Tested with:
BLCKSZ=8192
TESTCYCLES=500000

Result:
Collecting sizing information ...
Running random access timing test ...
Running sequential access timing test ...
Running null loop timing test ...
random test:       2541
sequential test:   2455
null timing test:  2389

random_page_cost = 2.303030
   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: "Dave Page"
Date:
Subject: Re:
Next
From: Mark Kirkwood
Date:
Subject: Re: Script to compute random page cost