Logical replication and synchronous replication

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Logical replication and synchronous replication
Date: 2017-04-18 10:55:01
Message-ID: CAD21AoD2FW95iMnYk9d7hA2KOhvbGvstXNvMgrqRnnVLounoaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

As doc of logical decoding said as a note[1], logical replication can
support the synchronous replication with some restriction. But In
addition to this, IIUC in logical replication decoded data is sent to
subscribers only when the commit WAL record is decoded (calls
ReorderBufferCommit) . It means that the local SQL execution and
applying the decoded data on subscriber side are always executed in a
sequential order, and the response time can simply be doubled or even
more (OTOH a good point is that decoded data of aborted transaction is
never sent to subscriber). I think there will be a lot of peoples who
want to use logical synchronous replication but this is a big
restriction for such user. I think we should document it or deal with
it.
Thought?

[1] https://www.postgresql.org/docs/devel/static/logicaldecoding-synchronous.html

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2017-04-18 10:55:17 Re: Partition-wise join for join between (declaratively) partitioned tables
Previous Message Simon Riggs 2017-04-18 10:54:30 Re: Failed recovery with new faster 2PC code