Message-ID: <3B4BC8BA.2AC613C4@postgresql.org>
Date: Wed, 11 Jul 2001 13:32:10 +1000
From: Justin Clift <justin@postgresql.org>
MIME-Version: 1.0
To: Philip Molter <philip@datafoundry.net>
CC: Adam Manock <abmanock@planetcable.net>, pgsql-general@postgresql.org
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
References: <3B4AC78F.9A9A5B45@regaltronic.com>
	<5.1.0.14.2.20010710072714.0234d120@pop.planetcable.net>
	<20010710090607.M12723@datafoundry.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi all,

Just added these figures to a new document :

http://techdocs.postgresql.org/techdocs/perftuningfigures.php

As people provide/submit figures and details of the equipment they use,
I'll post them onto this page.

Hopefully it will become a good set of real world guidelines for people,
etc.

Standardised benchmarks would be nice to though.

:-)

Regards and best wishes,

Justin Clift

Philip Molter wrote:
> 
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://www.postgresql.org/search.mpl