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
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? |
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 |
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? |