Carlos Henrique Reimer <carlos.rei...@opendb.com.br> writes: > Extracted ulimits values from postmaster pid and they look as expected:
> [root@00002-NfseNet ~]# cat /proc/2992/limits > Limit Soft Limit Hard Limit > Units > Max address space 1024000000 unlimited > bytes So you've got a limit of 1GB on process address space ... that's probably why it's burping on allocations of a couple hundred meg, especially if you have a reasonably large shared_buffers setting. You might as well be running a 32-bit build (in fact, a 32-bit build could still do a lot better than that). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general