On Mon, Aug 3, 2009 at 10:15 AM, Brian Modra<brian@zwartberg.com> wrote:
> 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,
Is there a valid reason you're NOT considering RAID-1 here? I hope
RAID-0 is a typo.
> 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.
Then I question the expertise of your experts. RAID5 is not fine.
It's slow, more prone to loss due to drive loss, and generally not a
good choice for databases.
I would gladly have more SATA drives in a RAID-10 than fewer SAS
drives in a RAID-5.
if someone is worried about "wasting" disk space tell them to worry
about something else, like losing data.
