| From: | "Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com> |
|---|---|
| To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Script to compute random page cost |
| Date: | 2002-09-09 11:50:59 |
| Message-ID: | 4D618F6493CE064A844A5D496733D66703904B@freedom.icomedias.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2002-09-09 11:52:38 | Re: Script to compute random page cost |
| Previous Message | Oliver Elphick | 2002-09-09 11:31:39 | pg_dump problems in upgrading |