| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Justin Clift <justin(at)postgresql(dot)org> |
| Cc: | Mark Kirkwood <markir(at)slingshot(dot)co(dot)nz>, 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-10-12 14:45:32 |
| Message-ID: | 200210121445.g9CEjXw16090@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(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 | Bruno Wolff III | 2002-10-12 15:45:13 | Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.) |
| Previous Message | Bruce Momjian | 2002-10-12 14:37:32 | Re: MySQL vs PostgreSQL. |