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.
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 |