[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?
From:       Simon Riggs <simon () 2ndquadrant ! com>
Date:       2007-09-08 6:28:24
Message-ID: 1189232904.4281.19.camel () ebony ! site
[Download RAW message or body]

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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
[prev in list] [next in list] [prev in thread] [next in thread]