RAID for the DB filesystem

From: Brian Modra <brian(at)zwartberg(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: RAID for the DB filesystem
Date: 2009-08-03 16:15:41
Message-ID: 5a9699850908030915i56dcee6cqb7fcce7b1af60dcb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
my database is hit with constant inserts to 6 main tables (200 inserts
per minute to one of the tables, less to the others), some updates,
but then the selects:
- large retrievals of randomly different sections of the database
(indexed maps by postgis). This data is static.
- medium sized retrievals of the same tables that are receiving the
inserts. By mediou sized, I mean typically 200 rows at once. These
retrievals are also randomly different to each other, and typically
retrieving the newly inserted data rather than the more historical.
The database size is about 300GB and growing.

What sort of hardware config would you advise?
I'm thinking of 2x300GB SATA RAID 0 for the OS and application files,
and 6x300GB SAS RAID 10 for the database... but some experts have said
RAID 5 is fine. I'm inlined to think RAID 10, but I'm not an expert.
Your advice will be much appreciated.
Thanks
Brian
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-08-03 17:44:19 Re: Postgres has stopped listening on port 5432...
Previous Message Tom Lane 2009-08-03 15:49:56 Re: Question on start server using PG_CTL