Synchronous replication hack for 9.0?

From: Yang Zhang <yanghatespam(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Synchronous replication hack for 9.0?
Date: 2010-09-27 07:08:50
Message-ID: AANLkTikOWFwhRXccWz140mCpWUJNG1fWZqj4oM3enJo9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I realize that synchronous replication is in the works for 9.1, but
for 9.0, could you hack your way to synchronous replication by polling
the standby's pg_last_xlog_receive_location() and waiting until it's
>= pg_current_xlog_location() from your last transaction? Any major
pitfalls here (besides the need to balance polling frequency and
latency)? Any recommended polling periods?

Aside: would 9.1's synchronous replication be adding anything that
lowers the replication delay compared to asynchronous replication? Or
could the changes be summarized as "commits now wait for the standby"?
--
Yang Zhang
http://yz.mit.edu/

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-09-27 07:27:48 Re: pgcluster
Previous Message Padmanabha, Shruthi (UMKC-Student) 2010-09-27 05:30:31 Database Cluster Initialisation Failed" error during PostgreSQL install