Re: Kernel kills postgres process - help need

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Kernel kills postgres process - help need
Дата
Msg-id 20080109152155.4254d03f@commandprompt.com
обсуждение исходный текст
Ответ на Re: Kernel kills postgres process - help need  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: Kernel kills postgres process - help need  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 09 Jan 2008 14:17:14 -0800
Jeff Davis <pgsql@j-davis.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-----

В списке pgsql-general по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Kernel kills postgres process - help need
Следующее
От: "Richard Brown"
Дата:
Сообщение: Storing and querying boolean fields