Re: Really out of memory?
От | Ben Chobot |
---|---|
Тема | Re: Really out of memory? |
Дата | |
Msg-id | Pine.LNX.4.64.0906021227030.25644@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Really out of memory? (John R Pierce <pierce@hogranch.com>) |
Ответы |
Re: Really out of memory?
|
Список | 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 по дате отправления: