Re: Postgres server crash

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Postgres server crash
Дата
Msg-id 87irh03gk2.fsf@mid.deneb.enyo.de
обсуждение исходный текст
Ответ на Re: Postgres server crash  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-performance
* Jim C. Nasby:

> What's interesting is that apparently FreeBSD also has overcommit (and
> IIRC no way to disable it), yet I never hear people going off on OOM
> kills in FreeBSD. My theory is that FreeBSD admins are smart enough to
> dedicate a decent amount of swap space, so that by the time you got to
> an OOM kill situation you'd be so far into swapping that the box would
> be nearly unusable.

I've seen OOM situations with our regular "use twice as much swap
space as there is RAM in the machine" rule.  Perhaps Linux is just
paging too fast for this to work. 8-P

By the way, the sysctl setting breaks some applications and
programming environments, such as SBCL and CMUCL.

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

Предыдущее
От: Guido Neitzer
Дата:
Сообщение: Re: shared_buffers > 284263 on OS X
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: When to vacuum a table?