Re: Really out of memory? - Mailing list pgsql-general

From Ben Chobot
Subject Re: Really out of memory?
Date
Msg-id Pine.LNX.4.64.0906021143050.25644@localhost.localdomain
Whole thread Raw
In response to Re: Really out of memory?  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Really out of memory?
List pgsql-general
On Tue, 2 Jun 2009, Martijn van Oosterhout wrote:

> On Tue, Jun 02, 2009 at 11:10:04AM -0700, Ben Chobot wrote:

>> May 31 02:59:40 sfmelwss postgres[30103]: [1-1] ERROR:  out of memory
>> May 31 02:59:40 sfmelwss postgres[30103]: [1-2] DETAIL:  Failed on request of size 16777212.
>
> Add even more swap. By turning overcommit off you make the kernel
> really pessimistic about how much memory is in use.

Is it so pessimistic that it won't try to swap out 16MB into almost 1GB of
free swap? That seems surprising to me.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Really out of memory?
Next
From: Tom Lane
Date:
Subject: Re: Really out of memory?