From: | Justin Clift <justin(at)postgresql(dot)org> |
---|---|
To: | Philip Molter <philip(at)datafoundry(dot)net> |
Cc: | Adam Manock <abmanock(at)planetcable(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Performance tuning for linux, 1GB RAM, dual CPU? |
Date: | 2001-07-11 03:32:10 |
Message-ID: | 3B4BC8BA.2AC613C4@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-hackers |
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(at)datafoundry(dot)net
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
From | Date | Subject | |
---|---|---|---|
Next Message | Mahesh Guleria | 2001-07-11 10:30:45 | Can we increase the no. of users in postgres |
Previous Message | Xue-Feng Yang | 2001-07-11 03:24:26 | Re: newbie question |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-07-11 03:37:15 | Re: embedded SQL cursos declare fails |
Previous Message | Justin Clift | 2001-07-11 03:26:54 | Re: [GENERAL] Re: QUERY - Including the new LDP PostgreSQL HOWTO in the main PostgreSQL distribution |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2001-07-11 04:15:35 | docs Japanese translation |
Previous Message | Bruce Momjian | 2001-07-11 03:32:00 | Re: Re: Encrypting pg_shadow passwords |