Re: Tuning 7.2? Different than 7.1.3?

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(at)megazone23(dot)bigpanda(dot)com>
> > Date: Tue, 12 Mar 2002 13:14:38 -0800 (PST)
> > To: Hunter Hillegas <lists(at)lastonepicked(dot)com>
> > Cc: PostgreSQL <pgsql-general(at)postgresql(dot)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.
>