From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Ben Chobot <bench(at)silentmedia(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Really out of memory? |
Date: | 2009-06-02 18:45:43 |
Message-ID: | 16518.1243968343@sss.pgh.pa.us |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ben Chobot <bench(at)silentmedia(dot)com> writes:
> 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.
So the kernel isn't letting PG have any more memory.
> That seems pretty self-explainitory. But I'm not so sure, because SAR
> says:
> ...
> ...which indicates there was still plenty of space left in swap.
Which the kernel isn't letting us use. Check the "ulimit" settings
that the postmaster is being started with. On a Linux box, any of
the -d -m or -v settings might cause this.
It's possible you are running out of 32-bit address space in the backend
process, but what seems more likely is that the per-process ulimit is
unreasonably small.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-06-02 18:47:55 | Re: Change view definition - do not have to drop it |
Previous Message | Ben Chobot | 2009-06-02 18:45:11 | Re: Really out of memory? |