- Mailing list pgsql-admin

From John Allgood
Subject
Date
Msg-id 200402242123.i1OLNrmN003788@mxsf24.cluster1.charter.net
Whole thread Raw
List pgsql-admin
Hello

    I am working on installing and configuring a Postgres database
server. I am running Redhat Enterprise ES 3.0 and Redhat Database 3.0.
"Postgres version 7.3.4-11". This server will host 150-200 users. There will
be about 9 database in our cluster ranging anywhere from 500MB to 3GB The
hardware is a dual Xeon running at 2.8GHZ, 4GB RAM, Ultra 320 SCSI hard
drives running on Adaptec Ultra Raid Controllers.
    I am planning on separating the OS, Data, WAL on to separate drives
which will be mirrored. I am looking for input on setting kernel parameters,
and Postgres server runtime parameters and other setting relating to tuning.
Also is there any benchmarking tools available that will help me tune this
server.


Thanks

John Allgood - ESC
System Administrator
770.535.5049



pgsql-admin by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Tsearch1 problem
Next
From: James Taylor
Date:
Subject: Idle processes won't die