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/
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 |