MIME-Version: 1.0
In-Reply-To: 
 <CAD7Ssm-JLz1nM1zd_dgVGWWMB+Bq=3QCWWigaZV7xu+_mQ_qWQ@mail.gmail.com>
References: 
 <CAD7Ssm9S__ZQCOq2GEN0G0rrs_4U6aqXiLaX0hh0Ts8JH_LY2w@mail.gmail.com>
 <A737B7A37273E048B164557ADEF4A58B17C5ED75@ntex2010i.host.magwien.gv.at>
 <528F4BE2.7000400@gmx.net>
 <A737B7A37273E048B164557ADEF4A58B17C5EDDF@ntex2010i.host.magwien.gv.at>
 <CAD7Ssm-JLz1nM1zd_dgVGWWMB+Bq=3QCWWigaZV7xu+_mQ_qWQ@mail.gmail.com>
Date: Fri, 22 Nov 2013 22:37:59 +0900
Message-ID: 
 <CAB7nPqSrkSy2BsdyxUXr=pY6=RetfQsEgPCRjOHJMTfFXU3Tfw@mail.gmail.com>
Subject: Re: PG replication across DataCenters
From: Michael Paquier <michael.paquier@gmail.com>
To: Kaushal Shriyan <kaushalshriyan@gmail.com>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>,
 =?ISO-8859-1?Q?Torsten_F=F6rtsch_=2AEXTERN=2A?= <torsten.foertsch@gmx.net>,
 "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

On Fri, Nov 22, 2013 at 10:03 PM, Kaushal Shriyan
<kaushalshriyan@gmail.com> wrote:
> 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.
In the case of synchronous replication, master node waits for the
confirmation that a given transaction has committed on slave side
before committing itself. This wait period can cause some delay, hence
it is preferable to use sync replication with nodes that far from each
other.
-- 
Michael


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general