Re: shared_buffer=2*max_connections?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: shared_buffer=2*max_connections?
Date: 2001-07-20 20:52:59
Message-ID: 4963.995662379@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2001-07-20 21:07:56 shared_buffers revisited
Previous Message Bruce Momjian 2001-07-20 20:52:27 Re: shared_buffer=2*max_connections?