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?