| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | "Barry L(dot) Geipel" <barry(at)GeipelNet(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: random_page_cost |
| Date: | 2004-04-19 21:45:40 |
| Message-ID: | ljh880tkm23a4voic5u0s9gg5votskbba9@email.aon.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 14 Apr 2004 06:22:56 -0700, "Barry L. Geipel"
<barry(at)GeipelNet(dot)com> wrote:
>How should the random_page_cost be calculated?
There are so many factors involved that I'd say it cannot be calculated.
The best strategy is to start with the default value of 4 and only fine
tune it based on the run times of real world queries.
If you experience problems with certain queries, post a short
description of your problem and EXPLAIN ANALYSE output to the
-performance mailing list.
Servus
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kostas | 2004-04-19 22:25:01 | I cannot view the website of postreSQL correctly |
| Previous Message | Matt Adams | 2004-04-19 21:25:21 | Downgrading from Postgresql 7.4 to 7.1 |