I cant get the config file to load into my postgres. that's the
problem. I want to set it to 10k, but it is only still at 1000... I
save the file and restart the service..
yes, i ment 'pg_ctl reload', sry about that one.
On 6/22/05, Bricklen Anderson <BAnderson(at)presinet(dot)com> wrote:
> >> enable_seqscan = false
> >> enable_indexscan = true
> >> ..
> >> effective_cache_size = 10000
> >> random_page_cost = 2
> >> ..
> >> I save the file, type 'pg_crl reload' then enter 'psql database'.
> >> argus=> show effective_cache_size ;
> >> effective_cache_size
> >> ----------------------
> >> 1000
> >> (1 row)
> I assume that 'pg_crl' is a typo? That should read 'pg_ctl reload'
> Also, you said that your effective_cache_size = 10000, yet when you SHOW
> it's only 1000. A cut 'n paste error, or maybe your erroneous "pg_crl"
> trigger the reload?
> This e-mail may be privileged and/or confidential, and the sender does
> not waive any related rights and obligations. Any distribution, use or
> copying of this e-mail or the information it contains by other than an
> intended recipient is unauthorized. If you received this e-mail in
> error, please advise me (by return e-mail or otherwise) immediately.
In response to
pgsql-performance by date
|Next:||From: Frank Wiles||Date: 2005-06-22 14:52:27|
|Subject: Performance Tuning Article|
|Previous:||From: Paul Ramsey||Date: 2005-06-22 14:20:13|
|Subject: Re: Querying 19million records very slowly|