Re: performance drop on RAID5

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: Whole Thread | Raw Message | 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
---------------------------------

In response to

Browse pgsql-performance by date

  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