Re: slave restarts with kill -9 coming from somewhere, or nowhere

Поиск
Список
Период
Сортировка
От Bert
Тема Re: slave restarts with kill -9 coming from somewhere, or nowhere
Дата
Msg-id CAFCtE1ndNOsy5oZzQS8X7mSoh5PbhtiOHKA2igcBj_KwtC_OZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: slave restarts with kill -9 coming from somewhere, or nowhere  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
aha, ok. This was a setting pg_tune sugested. But I can understand how that is a bad idea.

wkr,
Bert


On Thu, Apr 4, 2013 at 8:17 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Bert <biertie@gmail.com> writes:
> These are my memory settings:
> work_mem = 4GB

> How is it possible that one connection (query) uses all the ram? And how
> can I avoid it?

Uh ... don't do the above.  work_mem is the allowed memory consumption
per query step, ie per hash or sort operation.  A complex query can
easily use multiples of work_mem.

                        regards, tom lane



--
Bert Desmet
0477/305361

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: slave restarts with kill -9 coming from somewhere, or nowhere
Следующее
От: John Reeve
Дата:
Сообщение: upgrading postgresql84 package from rhel-x86_64-server-5 repo