From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | ml ml <mliebherr99(at)googlemail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Postgres is eating up all my memory |
Date: | 2009-08-14 20:06:13 |
Message-ID: | dcc563d10908141306o36286ec0tdc7f1f41d0e79642@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)marlowe(at)gmail(dot)com> wrote:
> On Fri, Aug 14, 2009 at 7:04 AM, ml ml<mliebherr99(at)googlemail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-08-14 23:09:31 | Re: Preventing OS administrator/root account access to data |
Previous Message | Scott Marlowe | 2009-08-14 20:03:58 | Re: Postgres is eating up all my memory |