Oh I see that work_mem etc are in the pastebin. Yeah, 128M is pretty
high work_mem if all 75 connections are working hard that's 9.6Gig of
ram. which you haven't got.
On Fri, Aug 14, 2009 at 2:03 PM, Scott Marlowe wrote:
> On Fri, Aug 14, 2009 at 7:04 AM, ml ml wrote:
>> Hello List,
>>
>> postgr
On Fri, Aug 14, 2009 at 7:04 AM, ml ml wrote:
> Hello List,
>
> postgres 8.2 is not doing too much but eating up all my memory:
> http://pastebin.com/m4cf22ee2
> The postgresql.conf is at the very bottom of the pastebin.
>
> I guess this is a configuration issue. The CPUs are almost 100% idle
> but
Peter Steinheuser writes:
> Parameters like shared_buffers, work_mem are the ones you'll probably need
> to adjust.
> Work_mem is per user, and can actually be multiples per user, depending on
> what you're doing.
temp_buffers is per-process too --- if there's heavy use of temp tables
in this ap
Parameters like shared_buffers, work_mem are the ones you'll probably need
to adjust.
Work_mem is per user, and can actually be multiples per user, depending on
what you're doing.
On Fri, Aug 14, 2009 at 9:04 AM, ml ml wrote:
> Hello List,
>
> postgres 8.2 is not doing too much but eating up al
Hello List,
postgres 8.2 is not doing too much but eating up all my memory:
http://pastebin.com/m4cf22ee2
The postgresql.conf is at the very bottom of the pastebin.
I guess this is a configuration issue. The CPUs are almost 100% idle
but i seem to run out of memory.
Any idea what i could do here
