Re: Script to compute random page cost

From: Mark Kirkwood <markir(at)slingshot(dot)co(dot)nz>
To: Mario Weilguni <mario(dot)weilguni(at)icomedias(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Curt Sampson <cjs(at)cynic(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, nickf(at)ontko(dot)com, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Ray Ontko <rayo(at)ontko(dot)com>
Subject: Re: Script to compute random page cost
Date: 2002-09-10 10:33:19
Message-ID: 3D7DCA6F.2080404@slingshot.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was attempting to measure random page cost a while ago -
I used three programs in this archive :

http://techdocs.postgresql.org/markir/download/benchtool/

It writes a single big file and seems to give more realistic
measurements ( like 6 for a Solaris scsi system and 10 for a Linux ide
one...)

Have a look and see if you can cannibalize it for your program

Cheers

Mark

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Elphick 2002-09-10 10:47:53 Re: Script to compute random page cost
Previous Message Lee Kindness 2002-09-10 09:47:37 Location of database files?