From: Steve Poe <spoe@sfnet.cc>
Cc: pgsql-performance@postgresql.org
Subject: Follow-Up: How to improve db performance with $7K?
Date: Fri, 01 Apr 2005 02:01:01 +0000
Message-ID: <424CAB5D.9020807@sfnet.cc> (raw)
In-Reply-To: <1112107974.7903.28.camel@sixtyfour.internetstaff.com>
References: <42443863.4040302@sfnet.cc>
<4244A90B.2030200@sfnet.cc>
<42453273.2060509@turtle-entertainment.de>
<200503261255.59007.josh@agliodbs.com>
<42455DEC.2080301@sfnet.cc>
<1112049794.23284.29.camel@localhost.localdomain>
<424840AE.3050200@sfnet.cc>
<1112107974.7903.28.camel@sixtyfour.internetstaff.com>
Thanks for everyone's feedback on to best improve our Postgresql
database for the animal hospital. I re-read the PostgreSQL 8.0
Performance Checklist just to keep focused.
We purchased (2) 4 x 146GB 10,000rpm SCSI U320 SCA drive arrays ($2600)
and (1) Sun W2100z dual AMD64 workstation with 4GB RAM ($2500). We did
not need a rack-mount server, so I though Sun's workstation would do
fine. I'll double the RAM. Hopefully, this should out-perform our dual
2.8 Xeon with 4GB of RAM.
Now, we need to purchase a good U320 RAID card now. Any suggestions for
those which run well under Linux?
These two drive arrays main purpose is for our database. For those
messed with drive arrays before, how would you slice-up the drive array?
Will database performance be effected how our RAID10 is configured? Any
suggestions?
Thanks.
Steve Poe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: spoe@sfnet.cc
Subject: Re: Follow-Up: How to improve db performance with $7K?
In-Reply-To: <424CAB5D.9020807@sfnet.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox