Re: Postgres is eating up all my memory
От | Peter Steinheuser |
---|---|
Тема | Re: Postgres is eating up all my memory |
Дата | |
Msg-id | 56e56ea40908140617o34ef5a8cu1bac59c30bce0bfa@mail.gmail.com обсуждение исходный текст |
Ответ на | Postgres is eating up all my memory (ml ml <mliebherr99@googlemail.com>) |
Ответы |
Re: Postgres is eating up all my memory
|
Список | 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.
--
Peter Steinheuser
psteinheuser@myyearbook.com
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@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?
Cheers,
Mario
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Peter Steinheuser
psteinheuser@myyearbook.com
В списке pgsql-admin по дате отправления: