Skip site navigation (1) Skip section navigation (2)

Re: Hardware suggestions for high performance 8.3

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 (view raw or flat)
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

In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2008-06-25 15:24:23
Subject: Re: Hardware vs Software RAID
Previous:From: Greg SmithDate: 2008-06-25 13:50:39
Subject: Re: Postgresql update op is very very slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group