Re: 12 disks raid setup

From: Franck Routier <franck(dot)routier(at)axege(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 12 disks raid setup
Date: 2008-03-01 10:27:57
Message-ID: 1204367277.9116.16.camel@franck-gusty
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Le vendredi 29 février 2008 à 23:56 -0500, Greg Smith a écrit :
> Wording is intentional--if you don't have a battery for it, the cache has
> to be turned off (or set to write-through so it's only being used on
> reads) in order for the database to be reliable. If you can't finish
> writes after a power off, you can't cache writes and expect your database
> to survive for too long.

Well, am I just wrong, or the file system might also heavily rely on
cache, especially as I use XFS ?

So anyway Postgresql has no way to know if the data is really on the
disk, and in case of a brutal outage, the system may definitely lose
data, wether there is another level of caching (Raid controller) or
not...

Right ?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-03-01 12:44:13 Re: 12 disks raid setup
Previous Message Greg Smith 2008-03-01 04:56:54 Re: 12 disks raid setup