Re: Performance tuning for linux, 1GB RAM, dual CPU?

From: Philip Molter <philip(at)datafoundry(dot)net>
To: Adam Manock <abmanock(at)planetcable(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
Date: 2001-07-10 14:06:07
Message-ID: 20010710090607.M12723@datafoundry.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-hackers

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(at)datafoundry(dot)net

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2001-07-10 14:37:11 Re: problem in compilation.
Previous Message Janning Vygen 2001-07-10 13:21:37 Re: Performance tuning for linux, 1GB RAM, dual CPU?

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-10 14:07:41 Re: any disadvantage of PostgeSQL on Windows
Previous Message Tom Lane 2001-07-10 13:56:38 Re: [PATCH] Partial indicies again

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-07-10 14:16:09 Re: WaitOnLock: error on wakeup
Previous Message Hannu Krosing 2001-07-10 14:04:43 Re: Any tips for this particular performance problem?