Re: [PERFORM] The never ending quest for clarity on shared_buffers

2004-10-06 Thread Neil Conway
On Thu, 2004-10-07 at 08:26, Paul Ramsey wrote: > The shared_buffers are shared (go figure) :). It is all one pool shared > by all connections. Yeah, I thought this was pretty clear. Doug, can you elaborate on where you saw the misleading docs? > The sort_mem and vacuum_mem are *per*connection*

Re: [PERFORM] The never ending quest for clarity on shared_buffers

2004-10-06 Thread Paul Ramsey
Doug Y wrote: For idle persistent connections, do each of them allocate the memory specified by this setting (shared_buffers * 8k), or is it one pool used by all the connection (which seems the logical conclusion based on the name SHARED_buffers)? Personally I'm more inclined to think the latt