Re: Really out of memory?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Really out of memory?
Date: 2009-06-02 18:45:11
Message-ID: Pine.LNX.4.64.0906021143050.25644@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-06-02 18:45:43 Re: Really out of memory?
Previous Message Chris Browne 2009-06-02 18:43:19 Re: Schema, databse, or tables in different system folder