Postgres Pro
Downloads
Home   >   mailing lists

Re: Possible Redundancy/Performance Solution - Mailing list pgsql-performance

From Dennis Muhlestein
Subject Re: Possible Redundancy/Performance Solution
Date
Msg-id fvsian$2b8o$1@news.hub.org
Whole thread Raw
In response to Re: Possible Redundancy/Performance Solution  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
Tree view 
>
> 1) RAID1+0 to make one big volume
> 2) RAID1 for OS/apps/etc, RAID1 for database
> 3) RAID1 for OS+xlog, RAID1 for database
> 4) RAID1 for OS+popular tables, RAID1 for rest of database

Lots of good info, thanks for all the replies.  It seems to me then,
that the speed increase you'd get from raid0 is not worth the downtime
risk, even when you have multiple servers.  I'll start pricing things
out and see what options we have.

Thanks again,
Dennis

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: RAID 10 Benchmark with different I/O schedulers
Next
From: "Tarcizio Bini"
Date:
Subject: Query Optimization with Kruskal’s Algorithm