Hi all,
first of all I'd like to thank everyone who
responded to my earlier post. I have a much better understanding of postgres
performance tuning now. In case anyone's interested we've decided to go with RH9
and PostgreSQL 7.3 and we'll do the OS and DB tuning ourselves. (should be a
good learning experience)
We are now getting ready to purchase the hardware
that will be used to run the database server. We're spending quite a bit of
money on it because this will eventually, if things go well within two
months, become a production server. We're getting all RH certified hardware from
Dell. (Dell 2650)
We're now stuck on the question of what type of
RAID configuration to use for this server. RAID 5 offers the best fault
tolerance but doesn't perform all that well. RAID 10 offers much better
performance, but no hot swap. Or should we not use RAID at all. I know that
ideally the log (WAL) files should reside on a separate disk from the rest of
the DB. Should we use 4 separate drives instead? One for the OS, one for data,
one for WAL, one for swap? Or RAID 10 for everything plus 1 drive for WAL? Or
RAID 5 for everything?
We have the budget for 5 drives. Does anyone have
any real world experience with what hard drive configuration works best for
postgres? This is going to be a dedicated DB server. There are going to be a
large number of transactions being written to the database. (Information is
logged from a separate app through ODBC to postgres) And there will be some
moderately complex queries run concurrently to present this information in
the form of various reports on the web. (The app server is a separate machine
and will connect to the DB through JDBC to create the HTML reports)
Any thoughts, ideas, comments would be
appreciated.
Thank you,
Balazs Wellisch
Neu Solutions
|
- Re: [PERFORM] Hardware performance Balazs Wellisch
- Re: [PERFORM] Hardware performance Joe Conway
- Re: [PERFORM] Hardware performance Hannu Krosing
- Re: [PERFORM] Hardware performance Joe Conway
- Re: [PERFORM] Hardware performance Adam Witney
- Re: [PERFORM] Hardware performance Joe Conway
- Re: [PERFORM] Hardware performan... Adam Witney
- Re: [PERFORM] Hardware perfo... Joe Conway
- Re: [PERFORM] Hardware perfo... Jord Tanner
- Re: [PERFORM] Hardware perfo... Robert Creager
- Re: [PERFORM] Hardware performance Andrew Sullivan