Re: [GENERAL] Running out of memory the hard way ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Running out of memory the hard way ...
Дата
Msg-id 5604.1486649713@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Running out of memory the hard way ...  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
Bill Moran <wmoran@potentialtech.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Bill Moran wrote:
>>> What I feel is the best way to mitigate the situation, is to have some
>>> setting that limits the maximum RAM any backend can consume.

>> I've had some success using ulimit in the past,

> Hopefully having this in the list archives will make the search easier
> for the next person who has this issue. Does anyone know if there are
> any suggestions to this effect in the official documentation? If not,
> I'll try to make some time to submit a patch.

[ grepgrepgrep... ] There is not.  There are several mentions of ulimit
in the docs, but all of them point towards removing unreasonably-tight
default limits, not towards intentionally adding a limit.  I think
something in or near 18.4.2 "Resource Limits" might be appropriate.

            regards, tom lane


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

Предыдущее
От: Berend Tober
Дата:
Сообщение: Re: [GENERAL] Server SSL key with passphrase
Следующее
От: Jehan-Guillaume de Rorthais
Дата:
Сообщение: Re: [GENERAL] clarification about standby promotion