From: Robert D Oden <roden@dbasetek.com>
To: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Raid Configurations
Date: Thu, 16 Aug 2007 11:32:24 -0500
Message-ID: <46C47C18.7010707@dbasetek.com> (raw)
After reading many articles which indicate the more disk spindles the
better performance and separating indexes, WAL and data on different
sets of spindles, I've come up with a couple of questions.
We am planning to buy an external raid sub-system utilizing raid 10. The
sub-system will consist of 12 73GB SAS drives total.
Based on our data requirements we can set this system up using two
different configurations.
First, we could have two raid sets, one with two drives mirrored for
indexes and the other with four drives mirrored for data. Second, we
could configure as one raid set with six drives mirrored housing both
indexes and data.
Our environment consists of up to 10-20 users doing a variety of
queries. We have data entry, batch processing, customer lookups and
ad-hoc queries happening concurrently through out the day.
Almost all queries would be using indexes, so we were concerned about
performance of index lookups with only two spindles dedicated to indexes
(using the first configuration). We thought it may be better to put data
and indexes on one raid where index lookups and data retrieval would be
spread across all six spindles.
Any comments would be appreciated!
Second Question:
Would there be any problems/concerns with putting WAL files on the
server in a raid 10 configuration separate from external raid sub-system?
Best regards,
Doug
--
Robert D Oden
Database Marketing Technologies, Inc
951 Locust Hill Circle
Belton MO 64012-1786
Ph: 816-318-8840
Fax: 816-318-8841
roden@dbasetek.com
This email has been processed by SmoothZap - www.smoothwall.net
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: roden@dbasetek.com
Subject: Re: Raid Configurations
In-Reply-To: <46C47C18.7010707@dbasetek.com>
* 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