Re: Migrating to Postgresql and new hardware

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Lars <la(at)unifaun(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Migrating to Postgresql and new hardware
Date: 2011-01-19 07:49:12
Message-ID: AANLkTikjFcvRihuK6sHeahNyRZ0VQ1eQvGjFw-mTDcXK@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jan 18, 2011 at 3:56 AM, Lars <la(at)unifaun(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Lars 2011-01-19 08:17:46 Re: Migrating to Postgresql and new hardware
Previous Message Craig Ringer 2011-01-19 07:26:32 Re: Migrating to Postgresql and new hardware