Re: Vacuum causing crashes

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: Vacuum causing crashes
Дата
Msg-id m2slz8bk4h.fsf@Douglas-McNaughts-Powerbook.local
обсуждение исходный текст
Ответ на Re: Vacuum causing crashes  (David Mitchell <david.mitchell@telogis.com>)
Список pgsql-general
David Mitchell <david.mitchell@telogis.com> writes:

>> If you're running Linux, it's possible that your system is
>> overcommitted and low on memory and the kernel is picking random
>> processes to kill.  There should be entries in the syslogs related to
>> this, if that's what's happening.  There are ways to tell (some
>> versions of) Linux not to overcommit memory.
>
> Cheers Doug, that's exactly what it was. That explains a lot of
> mysterious process deaths recently.
>
> Thanks heaps

Glad to help!

I have /proc/sys/vm/overcommit_memory set to 2 on all my critical
servers...

-Doug

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

Предыдущее
От: David Mitchell
Дата:
Сообщение: Re: Vacuum causing crashes
Следующее
От: Scott Goldstein
Дата:
Сообщение: Postgres 8.0 windows processes, field testing, and Hibernate