"hubert depesz lubaczewski" wrote:
> On 19 Dec 2006 07:01:41 -0800, Angva <angvaw@gmail.com> wrote:
> >
> > shared_buffers = 57344
> > work_mem = 200000
> > maintenance_work_mem = 524288
> >
>
> work_mem seems to be high. what is you max_connections setting?
max_connections = 100
However we never come even close to 100 connections at once on this
database. Rarely, if ever, do we even reach 10. But I am unsure why
work_mem is set to 200000. I personally tuned shared_buffers and
maintenance_work_mem for performance, but I just don't know why
work_mem is what it is. So, I'll gladly accept any suggestions about
this setting. :)
Thanks a lot,
Mark