Re: Really out of memory?

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?