Re: ERROR: Out of memory - when connecting to database

Поиск
Список
Период
Сортировка
От Jakub Ouhrabka
Тема Re: ERROR: Out of memory - when connecting to database
Дата
Msg-id 4CD84B33.8080206@comgate.cz
обсуждение исходный текст
Ответ на Re: ERROR: Out of memory - when connecting to database  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
>>> what's the work_mem?
>>
>> 64MB
>
> that's *way* too much with 24GB of ram and>  1k connections. please
> lower it to 32MB or even less.

Thanks for your reply. You are generally right. But in our case most of
the backends are only waiting for notify so not consuming any work_mem.
The server is not swapping. On the other hand some queries profit from
it. So we think it's fine as is.

Regards,

Kuba


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

Предыдущее
От: Jason Long
Дата:
Сообщение: Full Vacuum/Reindex vs autovacuum
Следующее
От: Chris Barnes
Дата:
Сообщение: Re: ERROR: Out of memory - when connecting to database