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