Can you tell me in what way it affects performance? And How do I decide what value to set for the random_page_cost? Does it depend on any other factors?
Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> I am sorry, I am not aware of what random_page_cost is, as I am new to
> Postgres. What does it signify and how do I reduce random_page_cost?
It's a parameter in your postgresql.conf file. After you test it, you will
want to change it there and reload the server (pg_ctl reload).
However, you can test it on an individual connection:
(the default is 4.0)
Aglio Database Solutions
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-performance by date
|Next:||From: gnari||Date: 2004-11-22 20:01:42|
|Subject: Re: help needed -- sequential scan problem |
|Previous:||From: Josh Berkus||Date: 2004-11-22 19:57:38|
|Subject: Re: help needed -- sequential scan problem|