From: Vincent van Leeuwen <pgsql.spam@vinz.nl>
To: pgsql-performance@postgresql.org
Subject: the RAID question, again
Date: Wed, 16 Apr 2003 18:26:58 +0200
Message-ID: <20030416162657.GK1836@md2.mediadesign.nl> (raw)
Hi,
I want to ask the 'which RAID setup is best for PostgreSQL?' question again.
I've read a large portion of the archives of this list, but generally the
answer is 'depends on your needs' with a few different camps.
My needs are as follows: dedicated PostgreSQL server for a website, which does
much more select queries than insert/updates (although, due to a lot of
caching outside the database, we will be doing more updates than usual for a
website).
The machine which will be built for this is going to be something like a dual
Xeon 2.4GHz, 4GB RAM, and a SCSI hardware RAID controller with some cache RAM
and 6-7 36GB 15K rpm disks. We have good experiences with ICP Vortex
controllers, so I'll probably end up buying on of those again (the GDT8514RZ
looks nice: http://www.icp-vortex.com/english/product/pci/rzu320/8514rz_e.htm
)
We normally use Debian linux with a 2.4 kernel, but we're thinking we might
play around with FreeBSD and see how that runs before making the final choice.
The RAID setup I have in my head is as follows:
4 disks for a RAID 10 array, for the PG data area
2 disks for a RAID 1 array, for the OS, swap (it won't swap) and, most
importantly, WAL files
1 disk for hot spare
RAID 1 isn't ideal for a WAL disks because of the (small) write penalty, but
I'm not sure I want to risk losing the WAL files. As far as I know PG doesn't
really like losing them :) This array shouldn't see much I/O outside of the
WAL files, since the OS and PG itself should be completely in RAM when it's
started up.
RAID 5 is more cost-effective for the data storage, but write-performance is
much lower than RAID 10.
The hot-spare is non-negotiable, it has saved my life a number of times ;)
Performance and reliability are the prime concerns for this setup. We normally
run our boxes at extremely high loads because we don't have the budget we
need. Cost is an issue, but since our website is always growing at an insane
pace I'd rather drop some cash on a fast server now and hope to hold out till
the end of this year than having to rush out and buy another mediocre server
in a few months.
Am I on the right track or does anyone have any tips I could use?
On a side note: this box will be bought a few days or weeks from now and
tested during a week or so before we put it in our production environment (if
everything goes well). If anyone is interested in any benchmark results from
it (possibly even FreeBSD vs Linux :)) that can probably be arranged.
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
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: pgsql.spam@vinz.nl
Subject: Re: the RAID question, again
In-Reply-To: <20030416162657.GK1836@md2.mediadesign.nl>
References: <20030416162657.GK1836@md2.mediadesign.nl>
* 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