From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
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:36:08 |
Message-ID: | 20090602183608.GC1430@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jun 02, 2009 at 11:10:04AM -0700, Ben Chobot wrote:
> I have a linux postgres server in the field. Its version is:
>
> PostgreSQL 8.2.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-51)
>
> (aka postgresql-8.2.4-1PGDG)
>
> A few days ago, its log started showing this:
>
> 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.
Add even more swap. By turning overcommit off you make the kernel
really pessimistic about how much memory is in use.
> ...which indicates there was still plenty of space left in swap. Now, I
> realize I don't want to be actually using my swap, but I'm wondering if
> the out of memory messages are a red herring. Should I be looking at
> something else, like the number of processes, open files, or shared
> memory segments?
You got as much swap as memory, try doubling it.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2009-06-02 18:42:33 | Re: Really out of memory? |
Previous Message | Emi Lu | 2009-06-02 18:13:58 | Change view definition - do not have to drop it |