Re: Postgres is eating up all my memory

From: Peter Steinheuser <psteinheuser(at)myyearbook(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 13:17:56
Message-ID: 56e56ea40908140617o34ef5a8cu1bac59c30bce0bfa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <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?
>
> Cheers,
> Mario
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--
Peter Steinheuser
psteinheuser(at)myyearbook(dot)com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-08-14 13:59:24 Re: Postgres is eating up all my memory
Previous Message ml ml 2009-08-14 13:04:45 Postgres is eating up all my memory