Re: Maximum transaction rate - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Maximum transaction rate
Date
Msg-id 1236969481.7023.70.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: Maximum transaction rate  (Ben Chobot <bench@silentmedia.com>)
Responses Re: Maximum transaction rate
List pgsql-general
On Fri, 2009-03-13 at 11:17 -0700, Ben Chobot wrote:
> On Fri, 13 Mar 2009, Joshua D. Drake wrote:
>
> > On Fri, 2009-03-13 at 14:00 -0400, Tom Lane wrote:
> >> Marco Colombo <pgsql@esiway.net> writes:
> >>> You mean some layer (LVM) is lying about the fsync()?
> >>
> >> Got it in one.
> >>
> >
> > I wouldn't think this would be a problem with the proper battery backed
> > raid controller correct?
>
> It seems to me that all you get with a BBU-enabled card is the ability to
> get burts of writes out of the OS faster. So you still have the problem,
> it's just less like to be encountered.

A BBU controller is about more than that. It is also supposed to be
about data integrity. The ability to have unexpected outages and have
the drives stay consistent because the controller remembers the state
(if that is a reasonable way to put it).

Joshua D. Drake


>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: Re: Maximum transaction rate
Next
From: Ben Chobot
Date:
Subject: Re: Maximum transaction rate