Re: Kernel kills postgres process - help need - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Kernel kills postgres process - help need
Date
Msg-id dcc563d10801091459l52f22784nd400f28bf8e7b1b1@mail.gmail.com
Whole thread Raw
In response to Kernel kills postgres process - help need  (Hervé Piedvache <bill.footcow@gmail.com>)
Responses Re: Kernel kills postgres process - help need  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Jan 9, 2008 3:57 PM, Hervé Piedvache <bill.footcow@gmail.com> wrote:

SNIP

> 0+0
> Jan  9 20:30:48 db2 kernel: Free swap  = 15623168kB
> Jan  9 20:30:48 db2 kernel: Total swap = 15623172kB
> Jan  9 20:30:48 db2 kernel: Free swap:       15623168kB
> Jan  9 20:30:48 db2 kernel: oom-killer: gfp_mask=0x84d0, order=0
> Jan  9 20:30:48 db2 kernel: Mem-info:
> Jan  9 20:30:48 db2 kernel: DMA per-cpu:
> Jan  9 20:30:48 db2 postgres[7634]: [2-1] LOG:  background writer process (PID
> 7639) was terminated by signal 9

This makes no sense to me.  The OS is showing that there's
16G free swap.  Why is it killing things?  I'm betting there's some
bug with too large of a swap resulting in some kind of wrap around or
something.

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: count(*) and bad design was: Experiences with extensibility
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Kernel kills postgres process - help need