From: | Frank Wiles <frank(at)wiles(dot)org> |
---|---|
To: | Alexandre Barros <alexandre(at)vectorx(dot)com(dot)br> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: performance drop on RAID5 |
Date: | 2005-08-24 15:52:43 |
Message-ID: | 20050824105243.067f0ae5.frank@wiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Wed, 24 Aug 2005 11:43:05 -0300
Alexandre Barros <alexandre(at)vectorx(dot)com(dot)br> wrote:
> I've googled a little, and maybe the cluster size might be one
> problem, but despite that, the performance dropping when running on
> "server-class" hardware with RAID-5 SCSI-2 drives was way above my
> most delirious expectations... i need some help to figure out what is
> **so** wrong...
RAID-5 isn't great for databases in general. What would be better
would be to mirror the disks to redundancy or do RAID 1+0.
You could probably also increase your shared_buffers some, but
that alone most likely won't make up your speed difference.
---------------------------------
Frank Wiles <frank(at)wiles(dot)org>
http://www.wiles.org
---------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2005-08-24 16:02:51 | Re: performance drop on RAID5 |
Previous Message | PFC | 2005-08-24 15:36:35 | Re: Caching by Postgres |