On Tue, 12 Mar 2002, Hunter Hillegas wrote:
> What value would you recommend?
It depends on the amount of RAM in the machine and usage patterns.
I think the conventional wisdom I've seen expressed on list is that a
few thousand is a good place to start.
> > From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
> > Date: Tue, 12 Mar 2002 13:14:38 -0800 (PST)
> > To: Hunter Hillegas <lists@lastonepicked.com>
> > Cc: PostgreSQL <pgsql-general@postgresql.org>
> > Subject: Re: [GENERAL] Tuning 7.2? Different than 7.1.3?
> >
> >> In postgresql.conf:
> >>
> >> max_connections = 200
> >> shared_buffers = 400
> >
> > That shared_buffer setting is pretty low for that number of connections.
>