| From: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Very poor performance |
| Date: | 2010-08-17 22:27:45 |
| Message-ID: | 4C6B0CE1.80301@catalyst.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 18/08/10 06:19, Kevin Grittner wrote:
>
>
> Since you haven't set effective_cache_size, you're discouraging some
> types of plans which might be worth considering. This should
> normally be set to the sum of your shared_buffers setting and
> whatever is cached by the OS; try setting effective_cache_size to
> 15MB. Speaking of shared_buffers, are you really at the default for
> that, too? If so, try setting it to somewhere between 1GB and 4GB.
> (I would test at 1, 2, and 4 if possible, since the best setting is
> dependent on workload.)
>
>
>
Kevin - I'm guessing you meant to suggest setting effective_cache_size
to 15GB (not 15MB)....
Cheers
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-08-18 03:08:25 | Re: Very poor performance |
| Previous Message | Scott Marlowe | 2010-08-17 19:24:29 | Re: Vacuum Full + Cluster + Vacuum full = non removable dead rows |