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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@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 по дате отправления:

Предыдущее
От: ml ml
Дата:
Сообщение: Postgres is eating up all my memory
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres is eating up all my memory