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
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 |