Re: Vacuum causing crashes - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Vacuum causing crashes
Date
Msg-id m2slz8bk4h.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Re: Vacuum causing crashes  (David Mitchell <david.mitchell@telogis.com>)
List 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 by date:

Previous
From: David Mitchell
Date:
Subject: Re: Vacuum causing crashes
Next
From: Scott Goldstein
Date:
Subject: Postgres 8.0 windows processes, field testing, and Hibernate