Re: Missed check for too-many-children in bgworker spawning

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Missed check for too-many-children in bgworker spawning
Дата
Msg-id 20191104190945.GF6962@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Missed check for too-many-children in bgworker spawning  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Greetings,

* Andres Freund (andres@anarazel.de) wrote:
> On 2019-10-09 12:29:18 -0400, Robert Haas wrote:
> > I would say rather that if fork() is failing on your system, you have
> > a not very stable system.
>
> I don't think that's really true, fwiw. It's often a good idea to turn
> on strict memory overcommit accounting, and with that set, it's actually
> fairly common to see fork() fail with ENOMEM, even if there's
> practically a reasonable amount of resources. Especially with larger
> shared buffers and without huge pages, the amount of memory needed for a
> postmaster child in the worst case is not insubstantial.

I've not followed this thread very closely, but I agree with Andres here
wrt fork() failing with ENOMEM in the field and not because the system
isn't stable.

Thanks,

Stephen

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: cost based vacuum (parallel)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Excessive disk usage in WindowAgg