Re: The never ending quest for clarity on shared_buffers

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 latter
> choice, but I've seen references that alluded to both cases, but never a
> definitive answer.

The shared_buffers are shared (go figure) :).  It is all one pool shared
by all connections.  The sort_mem and vacuum_mem are *per*connection*
however, so when allocating that size you have to take into account your
expected number of concurrent connections.

Paul