MIME-Version: 1.0
In-Reply-To: 
 <A737B7A37273E048B164557ADEF4A58B17C5EDDF@ntex2010i.host.magwien.gv.at>
References: 
 <CAD7Ssm9S__ZQCOq2GEN0G0rrs_4U6aqXiLaX0hh0Ts8JH_LY2w@mail.gmail.com>
 <A737B7A37273E048B164557ADEF4A58B17C5ED75@ntex2010i.host.magwien.gv.at>
 <528F4BE2.7000400@gmx.net>
 <A737B7A37273E048B164557ADEF4A58B17C5EDDF@ntex2010i.host.magwien.gv.at>
From: Kaushal Shriyan <kaushalshriyan@gmail.com>
Date: Fri, 22 Nov 2013 18:33:32 +0530
Message-ID: 
 <CAD7Ssm-JLz1nM1zd_dgVGWWMB+Bq=3QCWWigaZV7xu+_mQ_qWQ@mail.gmail.com>
Subject: Re: PG replication across DataCenters
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: =?ISO-8859-1?Q?Torsten_F=F6rtsch_=2AEXTERN=2A?=
 <torsten.foertsch@gmx.net>,
 "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary=485b3979da845c7db304ebc3a5d4
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

--485b3979da845c7db304ebc3a5d4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Fri, Nov 22, 2013 at 6:14 PM, Albe Laurenz <laurenz.albe@wien.gv.at>wrot=
e:

> Torsten F=F6rtsch wrote:
> >> Don't use synchronous replication if you have a high transaction
> >> rate and a noticable network latency between the sites.
> >>
> >> Wait for the next bugfix release, since a nasty bug has just
> >> been discovered.
> >
> > Can you please explain or provide a pointer for more information?
>
> If you mean the bug I mentioned, see this thread:
>
> http://www.postgresql.org/message-id/20131119142001.GA10498@alap2.anaraze=
l.de
>
> Yours,
> Laurenz Albe
>

Hi,

I am not sure i understand the difference between async and sync
replication and on what scenarios i should use async or sync replication.
Does it mean if it is within same DC then sync replication is the best and
if it is across DC replication async is better than sync. Please help me
understand.

Regards,

Kaushal

--485b3979da845c7db304ebc3a5d4
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div class=3D"gmail_extra"><br><br><div class=3D"gmail=
_quote">On Fri, Nov 22, 2013 at 6:14 PM, Albe Laurenz <span dir=3D"ltr">&lt=
;<a href=3D"mailto:laurenz.albe@wien.gv.at" target=3D"_blank">laurenz.albe@=
wien.gv.at</a>&gt;</span> wrote:<br>


<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;p=
adding-left:1ex"><div>Torsten F=F6rtsch wrote:<br>
&gt;&gt; Don&#39;t use synchronous replication if you have a high transacti=
on<br>
&gt;&gt; rate and a noticable network latency between the sites.<br>
&gt;&gt;<br>
&gt;&gt; Wait for the next bugfix release, since a nasty bug has just<br>
&gt;&gt; been discovered.<br>
&gt;<br>
&gt; Can you please explain or provide a pointer for more information?<br>
<br>
</div>If you mean the bug I mentioned, see this thread:<br>
<a href=3D"http://www.postgresql.org/message-id/20131119142001.GA10498@alap=
2.anarazel.de" target=3D"_blank">http://www.postgresql.org/message-id/20131=
119142001.GA10498@alap2.anarazel.de</a><br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div><br></div><div class=3D"gmail_extra">Hi,</div><div class=
=3D"gmail_extra"><br></div><div class=3D"gmail_extra">I am not sure i under=
stand the difference between async and sync replication and on what scenari=
os i should use async or sync replication. Does it mean if it is within sam=
e DC then sync replication is the best and if it is across DC replication a=
sync is better than sync. Please help me understand.</div>

<div class=3D"gmail_extra"><br></div><div class=3D"gmail_extra">Regards,</d=
iv><div class=3D"gmail_extra"><br></div><div class=3D"gmail_extra">Kaushal<=
/div>
</div>

--485b3979da845c7db304ebc3a5d4--