Re: Script to compute random page cost

Justin Clift wrote:
> Hi all,
> 
> As an end result of all this, do we now have a decent utility by which
> end user admin's can run it against the same disk/array that their
> PostgreSQL installation is on, and get a reasonably accurate number for
> random page cost?
> 
> ie:
> 
> $ ./get_calc_cost
> Try using random_page_cost = foo
> 
> $
> 
> :-)

Right now we only have my script:
ftp://candle.pha.pa.us/pub/postgresql/randcost

It uses dd so it forks for every loop and shows a value for my machine
around 2.5.  I need to code the loop in C to get more accurate numbers.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073