Re: DRBD and Postgres: how to improve the perfomance? - Mailing list pgsql-performance

From Simon Riggs
Subject Re: DRBD and Postgres: how to improve the perfomance?
Date
Msg-id 1189232904.4281.19.camel@ebony.site
Whole thread Raw
In response to Re: DRBD and Postgres: how to improve the perfomance?  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: DRBD and Postgres: how to improve the perfomance?
List pgsql-performance
On Fri, 2007-09-07 at 23:54 +0200, Bernd Helmle wrote:
> --On Freitag, September 07, 2007 20:00:16 +0100 Simon Riggs
> <simon@2ndquadrant.com> wrote:
>
> > On Fri, 2007-09-07 at 11:37 +0200, Maila Fatticcioni wrote:
> >
> >>  protocol C;
> >
> > Try protocol B instead.
>
> But that would have an impact on transaction safety, wouldn't it? It will
> return immediately after reaching the remote buffer cache and you can't be
> sure your data hits the remote disk.

You're right, but the distinction is a small one. What are the chances
of losing two independent servers within a few milliseconds of each
other?

If performance is an issue it is a particularly important distinction.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


pgsql-performance by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: DRBD and Postgres: how to improve the perfomance?
Next
From: Dimitri
Date:
Subject: Re: optimize query with a maximum(date) extraction