Re: configurability of OOM killer - Mailing list pgsql-hackers

From Markus Bertheau
Subject Re: configurability of OOM killer
Date
Msg-id 684362e10802071845o3f4dd58auf1398c5aab40a56c@mail.gmail.com
Whole thread Raw
In response to Re: configurability of OOM killer  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: configurability of OOM killer  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
2008/2/8, Tom Lane <tgl@sss.pgh.pa.us>:
Martijn van Oosterhout <kleptog@svana.org> writes:
> On Thu, Feb 07, 2008 at 08:22:42PM +0100, Dawid Kuroczko wrote:
>> ....while we are at it -- one feature would be great for 8.4, an
>> ability to shange shared buffers size "on the fly".

> Shared memory segments can't be resized... There's not even a kernel
> API to do it.

Even if there were, it seems unlikely that we could reallocate shared
memory without stopping all active transactions, so it'd be barely less
invasive than a postmaster restart anyhow.


What about allowing shared_buffers to be only greater than it was at server start and allocating the extra shared_buffers in one or more additional shm segments?

Markus

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: 8.3 / 8.2.6 restore comparison
Next
From: "Jignesh K. Shah"
Date:
Subject: Re: Why are we waiting?