Re: Out of memory condition - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of memory condition
Date
Msg-id 29097.1418330778@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of memory condition  (Carlos Henrique Reimer <carlos.reimer@opendb.com.br>)
List pgsql-general
Carlos Henrique Reimer <carlos.reimer@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


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Out of memory condition
Next
From: Robert DiFalco
Date:
Subject: Re: Help Optimizing a Summary Query