Re: Performance Tuning - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Performance Tuning
Date
Msg-id 1140206812.22740.301.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Performance Tuning  ("Darryl W. DeLao Jr." <ddelao@gmail.com>)
List pgsql-general
On Fri, 2006-02-17 at 14:01, Darryl W. DeLao Jr. wrote:
> Running ver 7.3.10 in RHEL 3.0 ES.  If I change shared buffers, dont i
> have to change max connections as well?

You should update to a newer version of PostgreSQL if performance is
important to you.  7.3 was ok, but 8.1 is light years ahead of it.

No, the shared_buffers has to be at least twice as big as the max
connections.  It can be more than twice as big, that's just a minimum.

Read this:

http://www.varlena.com/GeneralBits/Tidbits/perf.html

pgsql-general by date:

Previous
From: "Darryl W. DeLao Jr."
Date:
Subject: Re: Performance Tuning
Next
From: Tom Lane
Date:
Subject: Re: How do I use the backend APIs