pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Balazs Wellisch <balazs@neusolutions.com>
To: pgsql-performance@postgresql.org
Subject: Hardware performance
Date: Wed, 16 Jul 2003 19:57:22 -0700
Message-ID: <004b01c34c0f$256bfb80$0600a8c0@home01> (raw)

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
balazs@neusolutions.com

view thread (20+ messages)  latest in thread

Message-ID: <004b01c34c0f$256bfb80$0600a8c0@home01>
Permalink:  ../004b01c34c0f$256bfb80$0600a8c0@home01/
Also on:    postgresql.org/message-id/004b01c34c0f$256bfb80$0600a8c0@home01

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: balazs@neusolutions.com
  Subject: Re: Hardware performance
  In-Reply-To: <004b01c34c0f$256bfb80$0600a8c0@home01>
  References: <004b01c34c0f$256bfb80$0600a8c0@home01>

* 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