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?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
