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

From Mario Weilguni
Subject Re: Script to compute random page cost
Date
Msg-id 4D618F6493CE064A844A5D496733D66703904B@freedom.icomedias.com
Whole thread Raw
In response to Script to compute random page cost  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> What do other people get for this value?
>
> Keep in mind if we increase this value, we will get a more sequential
> scans vs. index scans.

With the new script I get 0.929825 on 2 IBM DTLA 5400RPM (80GB) with a  3Ware
6400 Controller (RAID-1)

Best regards,Mario Weilguni


--  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 


pgsql-hackers by date:

Previous
From: Oliver Elphick
Date:
Subject: pg_dump problems in upgrading
Next
From: Oliver Elphick
Date:
Subject: Re: Script to compute random page cost