[GENERAL] shared_buffer=2*max_connections?

[Thalis A. Kalfigopoulos]

I see in postgresql.conf what seems to be the suggested way to go:

#shared_buffers = 2*max_connections # min 16

This seems to imply that every connection is to take 16kb of shmem on average. From my 
understanding this depends on the size of the query->involved relations, the sort_mem 
size etc.etc.

True/false?

TIA,
thalis


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl