| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com> |
| Cc: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Torsten Förtsch *EXTERN* <torsten(dot)foertsch(at)gmx(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PG replication across DataCenters |
| Date: | 2013-11-22 13:37:59 |
| Message-ID: | CAB7nPqSrkSy2BsdyxUXr=pY6=RetfQsEgPCRjOHJMTfFXU3Tfw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general |
On Fri, Nov 22, 2013 at 10:03 PM, Kaushal Shriyan
<kaushalshriyan(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2013-11-22 13:38:36 | Re: PG replication across DataCenters |
| Previous Message | Kaushal Shriyan | 2013-11-22 13:03:32 | Re: PG replication across DataCenters |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2013-11-22 13:38:36 | Re: PG replication across DataCenters |
| Previous Message | Jeff Trout | 2013-11-22 13:25:47 | tsvector stemmer issue |