From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: BBU still needed with SSD?
Date: Tue, 19 Jul 2011 06:19:37 -0400
Message-ID: <4E255A39.4000304@2ndQuadrant.com> (raw)
In-Reply-To: <1311047798.93674.YahooMailClassic@web111301.mail.gq1.yahoo.com>
References: <1311047798.93674.YahooMailClassic@web111301.mail.gq1.yahoo.com>
On 07/18/2011 11:56 PM, Andy wrote:
> I'm talking about after I get 2 Intel 320s, should I spend the extra
> money on a RAID BBU? Adding RAID BBU in this case wouldn't improve
> reliability, but does it improve performance? If so, how much
> improvement can it bring?
It won't improve performance enough that I would bother. The main
benefit of adding a RAID with BBU to traditional disks is that you can
commit much, much faster to the card RAM than the disks can spin. You
can go from 100 commits/second to 10,000 commits/second that way (in
theory--actually getting >2000 at the database level is harder).
Since the Intel 320 drives can easily hit 2000 to 4000 commits/second on
their own, using the cache that's built-in to the drive, the advantage
of adding a RAID card on top of that is pretty minimal. Adding a RAID
cache will help some, because that layer will be faster than the SSD at
absorbing writes, and putting another cache layer into a system always
helps with improving burst performance. But you'd probably be better
off using the same money to add more RAM, or more/bigger SSD drives.
The fundamental thing that RAID BBU units do--speed up commits--you will
only see minimal benefit from with these SSDs.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndQuadrant.com
Subject: Re: BBU still needed with SSD?
In-Reply-To: <4E255A39.4000304@2ndQuadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox