Re: Really out of memory? - Mailing list pgsql-general

From Ben Chobot
Subject Re: Really out of memory?
Date
Msg-id Pine.LNX.4.64.0906021227030.25644@localhost.localdomain
Whole thread Raw
In response to Re: Really out of memory?  (John R Pierce <pierce@hogranch.com>)
Responses Re: Really out of memory?
List pgsql-general
On Tue, 2 Jun 2009, John R Pierce wrote:

> 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?

work_mem is 1MB, but maintenance_work_mem is 16MB. So it's probably
autovacuum kicking off most of these messages.

>>  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?

Not that I can tell. There's nothing special in /etc/init.d/postgresql or
/etc/sysconfig/pgsql/postgresql, and ulimit -a shows:

core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
max nice                        (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 16127
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
max rt priority                 (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 16127
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

Is there a way to see what the limits are for a given pid? I don't see
anything obviously relevant in /proc/<pid>/....

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: warm standby with WAL shipping
Next
From: Emi Lu
Date:
Subject: Re: Change view definition - do not have to drop it