shared buffers in config

Started by Joseph Shraibmanover 23 years ago3 messagesgeneral
Jump to latest
#1Joseph Shraibman
jks@selectacast.net

If shared_buffers is always 2 * max_connections, what is the point of setting it in the
config file?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Joseph Shraibman (#1)
Re: shared buffers in config

Joseph Shraibman <jks@selectacast.net> writes:

If shared_buffers is always 2 * max_connections, what is the point of
setting it in the config file?

2 * max_connections is the enforced minimum, not the only value (or even
the recommended value; it's more like a desperation cutoff).

regards, tom lane

#3Joseph Shraibman
jks@selectacast.net
In reply to: Tom Lane (#2)
Re: shared buffers in config

So what exactly are shared_buffers used for?

Tom Lane wrote:

Show quoted text

Joseph Shraibman <jks@selectacast.net> writes:

If shared_buffers is always 2 * max_connections, what is the point of
setting it in the config file?

2 * max_connections is the enforced minimum, not the only value (or even
the recommended value; it's more like a desperation cutoff).

regards, tom lane