Re: Kernel kills postgres process - help need

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Hervé Piedvache <bill(dot)footcow(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Kernel kills postgres process - help need
Date: 2008-01-09 23:21:55
Message-ID: 20080109152155.4254d03f@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 09 Jan 2008 14:17:14 -0800
Jeff Davis <pgsql(at)j-davis(dot)com> wrote:

> I posted to LKML here:
>
> http://kerneltrap.org/mailarchive/linux-kernel/2007/2/12/54202
>
> because linux has a behavior -- which in my opinion is a bug -- that
> causes the OOM killer to almost always kill PostgreSQL first,
> regardless of whether it was truly the offending process or not.

If that isn't an argument for FreeBSD I don't know what is...

/linuxpoet

>
> So, find out which process truly caused the memory pressure that lead
> to the OOM being invoked, and fix that problem.
>
> You may also consider some other linux configuration options that make
> invocation of OOM killer less likely.
>
> Regards,
> Jeff Davis
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 2: Don't 'kill -9' the
> postmaster
>

- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHhVcVATb/zqfZUUQRAp0YAJ4ooisf5xRDvXegEl2f/r3TTTB4jACfSuFn
O1MUlow1sg++4zdoh6TGu6Y=
=JMWG
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Brown 2008-01-09 23:23:04 Storing and querying boolean fields
Previous Message Brown, Richard 2008-01-09 23:19:40 Storing and querying boolean fields