Re: Postgres is eating up all my memory

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:03:58
Message-ID: dcc563d10908141303t730113bft5559562e66eaa3aa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-08-14 20:06:13 Re: Postgres is eating up all my memory
Previous Message Alvaro Herrera 2009-08-14 16:53:07 Re: Vacuum Issue 8.2