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@svana.org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.