Date: Tue, 10 Jul 2001 09:06:07 -0500
From: Philip Molter <philip@datafoundry.net>
To: Adam Manock <abmanock@planetcable.net>
Cc: pgsql-general@postgresql.org
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
Message-ID: <20010710090607.M12723@datafoundry.net>
References: <3B4AC78F.9A9A5B45@regaltronic.com>
	<5.1.0.14.2.20010710072714.0234d120@pop.planetcable.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.16i
In-Reply-To: <5.1.0.14.2.20010710072714.0234d120@pop.planetcable.net>;
	from abmanock@planetcable.net on Tue, Jul 10, 2001 at 07:44:34AM
	-0400

On Tue, Jul 10, 2001 at 07:44:34AM -0400, Adam Manock wrote:
: Hi,
: 
: I am about to put a 7.1.2 server into production on RedHat 7.1
: The server will be dedicated to PostgreSQL, running a bare minimum of 
: additional services.
: If anyone has already tuned the configurable parameters on a dual PIII w/ 
: 1GB RAM then I
: will have a great place to start for my performance tuning!
: When I'm done I'll be posting my results here for the next first timer that 
: comes along.

I have a similar system.  It's a dual PII-450MHz Xeon with 512MB of RAM
running RH7.1 and 7.1.2.  As far as performance tuning goes, here's the
relevant lines from the postgresql.conf file we're using:

  max_connections = 64 # 1-1024
  sort_mem = 8192
  shared_buffers = 192
  fsync = false

Obviously, depending on your needs, you can adjust those.  If you've
got a 1GB of RAM, I'd set everything high and not worry about it.

* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* philip@datafoundry.net