Re: Article about PostgreSQL and RAID in Brazil

From: mudfoot(at)rawbw(dot)com
To: josh(at)agliodbs(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Article about PostgreSQL and RAID in Brazil
Date: 2004-09-16 23:00:19
Message-ID: 1095375619.414a1b034ba63@webmail.rawbw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Quoting Josh Berkus <josh(at)agliodbs(dot)com>:

> The first and most important step for RAID performance with PostgreSQL is to
>
> get a card with onboard battery back-up and enable the write cache for the
> card. You do not want to enable the write cache *without* battery back-up
>

I'm curious about this -- how do you avoid losing data if a cache stick dies?
Without redundancy, whatever hasn't been destaged to the physical media vanishes
Dual-controller external arrays (HDS, EMC, LSI, etc.) tend to mirror (though
algorithms vary) the cache in addition to battery backup. But do onboard arrays
tend to do this as well?

Mark

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Stephen Crowley 2004-09-17 01:51:11 Re: Large # of rows in query extremely slow, not using
Previous Message Jim C. Nasby 2004-09-16 22:19:43 Re: Article about PostgreSQL and RAID in Brazil