View Single Post

   
  #2 (permalink)  
Old 04-18-2008, 12:17 PM
Frank Wiles
 
Posts: n/a
Default Re: performance drop on RAID5

On Wed, 24 Aug 2005 11:43:05 -0300
Alexandre Barros <alexandre@vectorx.com.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@wiles.org>
http://www.wiles.org
---------------------------------


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote