From: Erik Myllymaki <erik.myllymaki@aviawest.com>
To: pgsql-performance@postgresql.org
Subject: hardare config question
Date: Fri, 28 Apr 2006 08:37:57 -0700
Message-ID: <445236D5.5060509@aviawest.com> (raw)
This is a question that I also posted on Dell hardware forums, and I realize it
probably belongs there more than here. But I am thinking someone might have
some anecdotal information that could help me and this post may help someone
else down the road.
My PowerEdge 1800 (dual 3ghz Xeon, 3GB ram) came with a single SATA drive. I
installed and developed a modest database application (Postgresql, Windows 2003
Server, Python) on it and was pretty impressed with the performance.
I wanted to add some more space, speed and reliability so I bought a used 3ware
9500s SATA raid card. I bought three more of the same drives (Seagate
ST3808110as) and configured them in RAID 5 (3 in RAID one as hot spare). I
reinstalled the OS and software (my efforts to ghost were not
fruitful...another story), and the first thing I did was run a sql script to
make tables, indexes, sequences etc for my app and import about 20MB of data.
When I had this installed on a single SATA drive running from the PE1800's
on-board SATA interface, this operation took anywhere from 65-80 seconds.
With my new RAID card and drives, this operation took 272 seconds!?
I did a quick search and found a few posts about how RAID 5 with Databases is a
poor choice and one in particular about Postgres and how you could expect
performance to be halved with RAID 5 over a single drive or RAID 1 (until you
get above 6 disks in your RAID 5 array). So, a poorly planned configuration on
my part.
I scrubbed the RAID config, made two RAID 1 containers (also read about how
moving database logs to a different partition than the database data is optimal
for speed and reliability). I installed the OS on the first RAID 1 volume, the
Postgresql apps and data on the other, and used Junction from sysinternals to
put the pg_xlogs back on the OS partition (does Postgresql have an easier way
to do this on Windows?).
Well, things didn't improve noticeably - 265 seconds.
Next step, turn on the 3ware RAID card's write cache (even though I have no
Battery Backup Unit on the RAID card and am warned about possible data loss in
the event of power loss).
This helped - down to 172 seconds.
Is this loss in performance just the normal overhead involved when adding a
raid card - writes now having to go to two drives instead of one? Or maybe is
the SATA interface on the Dell 1800s motherboard faster than the interface on
the 3ware raid card (SATA II ?).
Thanks for any help you guidance you can provide.
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: erik.myllymaki@aviawest.com
Subject: Re: hardare config question
In-Reply-To: <445236D5.5060509@aviawest.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