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

From John R Pierce
Subject Re: Really out of memory?
Date
Msg-id 4A257299.2040002@hogranch.com
Whole thread Raw
In response to Really out of memory?  (Ben Chobot <bench@silentmedia.com>)
Responses Re: Really out of memory?
List pgsql-general
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.

Thats a 16MB request  is that your work_mem size or something by any chance?


> 02:30:01 AM kbmemfree kbmemused  %memused kbbuffers  kbcached
> kbswpfree kbswpused  %swpused  kbswpcad
> 02:40:01 AM     13332   1003316     98.69    130448    198188
> 1034572     13996      1.33        32

so you only have 13MB memory free.  you have -do- have free swap, however.


hey, is any ULIMIT in effect for the postgres process?





pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Really out of memory?
Next
From: Ben Chobot
Date:
Subject: Re: Really out of memory?