Re: [PATCHES] Automatically setting work_mem - Mailing list pgsql-hackers

From daveg
Subject Re: [PATCHES] Automatically setting work_mem
Date
Msg-id 20060422212032.GD14283@sonic.net
Whole thread Raw
In response to Re: [PATCHES] Automatically setting work_mem  (David Fetter <david@fetter.org>)
Responses Re: Automatically setting work_mem
List pgsql-hackers
On Sat, Apr 22, 2006 at 01:49:25PM -0700, David Fetter wrote:
> On Sat, Apr 22, 2006 at 01:14:42PM -0700, David Gould wrote:
>
> > To avoid running out of swap and triggering the oom killer we have
> > had to reduce work_mem below what we prefer.
>
> Dunno about your work_mem, but you can make sure the OOM killer
> doesn't kill you as follows <http://lwn.net/Articles/104185/>.

Or I could run with overcommit turned off, but we like overcommit because
things like vaccuum appear to allocate maint_work_mem when they start, so
if that is set at say 100 Mb it will allocate 100 Mb even to vacuum a 2
page table. Overcommit lets this sort of thing get by without createing
a need for even more swap.

-dg


--
David Gould                      daveg@sonic.net
If simplicity worked, the world would be overrun with insects.

pgsql-hackers by date:

Previous
From: Gevik Babakhani
Date:
Subject: Question about the MemoryContext
Next
From: Tom Lane
Date:
Subject: Re: Question about the MemoryContext