Re: linux, memory (mis)accounting/reporting, and the planner/optimizer

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: "M(dot) Edward (Ed) Borasky" <znmeb(at)cesmail(dot)net>
Cc: Dave Youatt <dave(at)fyreball(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: linux, memory (mis)accounting/reporting, and the planner/optimizer
Date: 2009-01-22 16:59:48
Message-ID: Pine.GSO.4.64.0901221151580.4266@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2009-01-22 17:14:17 Re: postgresql 8.3 tps rate
Previous Message Joshua D. Drake 2009-01-22 16:37:47 Re: postgresql 8.3 tps rate