2008/2/8, Tom Lane <[EMAIL PROTECTED]>: > > Martijn van Oosterhout <[EMAIL PROTECTED]> 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