Re: Postgres server crash - Mailing list pgsql-performance

From Florian Weimer
Subject Re: Postgres server crash
Date
Msg-id 87irh03gk2.fsf@mid.deneb.enyo.de
Whole thread Raw
In response to Re: Postgres server crash  ("Jim C. Nasby" <jim@nasby.net>)
List 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 by date:

Previous
From: Guido Neitzer
Date:
Subject: Re: shared_buffers > 284263 on OS X
Next
From: "Kevin Grittner"
Date:
Subject: Re: When to vacuum a table?