Re: shared_buffer=2*max_connections?

"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:
> I see in postgresql.conf what seems to be the suggested way to go:
> #shared_buffers = 2*max_connections # min 16

That's a *minimum allowed* value intended to ensure that you won't see
"out of buffers" failures.  In practice, on any reasonably modern
machine I'd recommend a shared_buffers setting of at least a couple
thousand.  You might need to twiddle kernel parameters to let it go that
high, however.

            regards, tom lane