Postgres Pro
Downloads
Home   >   mailing lists

Re: Migrating to Postgresql and new hardware - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Migrating to Postgresql and new hardware
Date
Msg-id AANLkTikjFcvRihuK6sHeahNyRZ0VQ1eQvGjFw-mTDcXK@mail.gmail.com
Whole thread Raw
In response to Migrating to Postgresql and new hardware  (Lars <la@unifaun.com>)
List pgsql-performance
Tree view 
On Tue, Jan 18, 2011 at 3:56 AM, Lars <la@unifaun.com> wrote:

> Any comments on the setups? How would an alternative with 15K disks (6 RAID 10 + 1 spare, or even 10 RAID10 + 1
spare)compare? 

RAID-10 is going to trounce RAID-5 for writes, which is where you
usually have the most issues.

> How would these alternatives compare in I/O performance compared to the old setup?

Only testing can tell, but I've seen 4 SATA drives in RAID-10 with no
caching or fancy controller beat a 4 disk RAID-5 with BBU controller
more than once.

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Migrating to Postgresql and new hardware
Next
From: Achilleas Mantzios
Date:
Subject: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2