Re: SSD Drives

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz>, David Rees <drees76(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: SSD Drives
Date: 2014-04-04 19:08:56
Message-ID: CAOR=d=1m0nAE0yQrQhui=U+-+A=z6=je4JWo0Vvxt0OkkwVqYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 4, 2014 at 11:15 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Fri, Apr 4, 2014 at 11:04 AM, Steve Crawford
> <scrawford(at)pinpointresearch(dot)com> wrote:
>> On 04/03/2014 12:44 PM, Brent Wood wrote:

>> 2. Do I need both BBU on the RAID *and* capacitor on the SSD or just on one?
>> Which one? I'm suspecting capacitor on the SSD and write-through on the
>> RAID.
>
> You need both. The capacitor protects the drive, the BBU protects the
> raid controller.

You don't technically need the BBU / flashback memory IF the
controller is in write through. My experience has been that the BBU
helps a lot on write heavy applications or to get maximum performance
for your money. On most cards, it's < $100 so unless you can
definitively show no real performance loss without one, get one. OTOH
it's worth testing to be sure. But the BBU does a lot to reorder
writes and such and flattens out bursty write performance very well.
It also speeds up checkpointing if / when it has to occur.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-04-04 19:18:17 Re: SSD Drives
Previous Message Tom Lane 2014-04-04 18:24:30 Re: Indices and Foreign Tables