| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | Henrik <henke(at)mac(dot)se> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Hardware suggestions for high performance 8.3 |
| Date: | 2008-06-25 13:56:50 |
| Message-ID: | Pine.GSO.4.64.0806250951320.4129@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, 25 Jun 2008, Henrik wrote:
> 4 x 146 GB SAS disk in RAID 1+0 for database
> 6 x 750 GB SATA disks in RAID 1+0 or RAID 5 for OS and transactions logs.
The transaction logs are not that big, and there's very little value to
striping them across even two disks. You should just get more SAS disks
instead and make them available to the database, adding more spindles for
random I/O is much more important. Separating out a single RAID-1 pair
from that set to hold the logs is a reasonable practice, with a good
battery-backed controller even that might not buy you anything useful.
--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-06-25 15:24:23 | Re: Hardware vs Software RAID |
| Previous Message | Greg Smith | 2008-06-25 13:50:39 | Re: Postgresql update op is very very slow |