On Fri, Feb 08, 2008 at 09:59:37AM +0100, Dawid Kuroczko wrote: > That is true. However it is possible to allocate more than one shared memory > segment. At simplest I would assume that DBA should specify minimum > shared memory size (say, 1GB) and expected maximum (2GB). And that > between minimum and maximum SHM should be allocated in reasonably > sized chunks. Say 128MB chunks. So that DBA could resize shared buffers > to 1.5GB, decide this was not a good idea after all and reduce it to 1280MB.
I think the biggest problem is that the shared memory segments have to be mapped to the same address in every process. The chance that can happen after the server has been running for a while is small. Perhaps if the postmaster allocated it waited for all the clients to refork... Would people be OK with an indeterminate delay between changing the setting and when it takes effect? Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution > inevitable. > -- John F Kennedy
signature.asc
Description: Digital signature
