| From: | Douglas McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | David Mitchell <david(dot)mitchell(at)telogis(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Vacuum causing crashes |
| Date: | 2005-06-24 01:48:14 |
| Message-ID: | m2slz8bk4h.fsf@Douglas-McNaughts-Powerbook.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
David Mitchell <david(dot)mitchell(at)telogis(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Goldstein | 2005-06-24 04:39:07 | Postgres 8.0 windows processes, field testing, and Hibernate |
| Previous Message | David Mitchell | 2005-06-24 01:39:25 | Re: Vacuum causing crashes |