Thread: shared buffers in config

shared buffers in config

From
Joseph Shraibman
Date:
If shared_buffers is always 2 * max_connections, what is the point of setting it in the
config file?


Re: shared buffers in config

From
Tom Lane
Date:
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

Re: shared buffers in config

From
Joseph Shraibman
Date:
So what exactly are shared_buffers used for?

Tom Lane wrote:
> 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