Re: Maximum transaction rate

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Maximum transaction rate
Дата
Msg-id 1236970796.7023.73.camel@jd-laptop.pragmaticzealot.org
обсуждение исходный текст
Ответ на Re: Maximum transaction rate  (Ben Chobot <bench@silentmedia.com>)
Ответы Re: Maximum transaction rate  (Christophe <xof@thebuild.com>)
Список pgsql-general
On Fri, 2009-03-13 at 11:41 -0700, Ben Chobot wrote:
> On Fri, 13 Mar 2009, Joshua D. Drake wrote:
>
> >> 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).
>
> Of course. But if you can't reliably flush the OS buffers (because, say,
> you're using LVM so fsync() doesn't work), then you can't say what
> actually has made it to the safety of the raid card.

Wait, actually a good BBU RAID controller will disable the cache on the
drives. So everything that is cached is already on the controller vs.
the drives itself.

Or am I missing something?

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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Maximum transaction rate
Следующее
От: Christophe
Дата:
Сообщение: Re: Maximum transaction rate