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<scott.marlowe@gmail.com> wrote:
> On Fri, Aug 14, 2009 at 7:04 AM, ml ml<mliebherr99@googlemail.com> 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 i seem to run out of memory.
>>
>> Any idea what i could do here?
>
> Post what has been changed from the defaults on postgresql.conf. I'm
> guessing work_mem is a little big, but that's just a guess.
>
--
When fascism comes to America, it will be intolerance sold as diversity.