Re: linux, memory (mis)accounting/reporting, and the planner/optimizer - Mailing list pgsql-performance

From Greg Smith
Subject Re: linux, memory (mis)accounting/reporting, and the planner/optimizer
Date
Msg-id Pine.GSO.4.64.0901221151580.4266@westnet.com
Whole thread Raw
In response to Re: linux, memory (mis)accounting/reporting, and the planner/optimizer  ("M. Edward (Ed) Borasky" <znmeb@cesmail.net>)
Responses Re: linux, memory (mis)accounting/reporting, and the planner/optimizer
List pgsql-performance
On Wed, 21 Jan 2009, M. Edward (Ed) Borasky wrote:

> Re the OOM killer -- maybe a patch to the kernel could make things
> "better"??

People have tried to raise awareness of it; sample:

http://lkml.org/lkml/2007/2/9/275

without much success.  The Linux kernel hackers dislike the whole approach
PostgreSQL uses to allocate shared memory anyway--witness the backlash
against any attempt to raise SHMMAX.

I found the long thread that beats this issue to death in the archives
again:

http://archives.postgresql.org/pgsql-hackers/2008-02/msg00026.php

That discussion should get raised to a higher profile eventually, maybe a
summary on the wiki.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: postgresql 8.3 tps rate
Next
From: Merlin Moncure
Date:
Subject: Re: postgresql 8.3 tps rate