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?