Re: Script to compute random page cost

From: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, TESTCYCLES=500000(at)cybertec(dot)at
Subject: Re: Script to compute random page cost
Date: 2002-09-11 07:55:48
Message-ID: 3D7EF704.3000609@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2002-09-11 08:04:48 Re: Script to compute random page cost
Previous Message Dave Page 2002-09-11 07:20:22 Re: