Carlos Henrique Reimer <carlos.reimer@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
