digoal
2023-03-24
PostgreSQL , PolarDB , 逻辑复制 , 发布 , 订阅 , binary format COPY , 表同步
PostgreSQL 16 内置逻辑复制(发布、订阅) 初始化表同步数据阶段性能提升: 采用binary format copy.
要求发布和订阅端都是版本16以上.
Allow logical replication to copy tables in binary format.
author Amit Kapila <akapila@postgresql.org>
Thu, 23 Mar 2023 03:15:51 +0000 (08:45 +0530)
committer Amit Kapila <akapila@postgresql.org>
Thu, 23 Mar 2023 03:15:51 +0000 (08:45 +0530)
commit ecb696527c01908d54b7a7aa2bd9179585b46459
tree db61bab00788f7b3ab46d2558102095fdb11676c tree
parent 4f1882b960596c35d62c78fb44e14913eff49a85 commit | diff
Allow logical replication to copy tables in binary format.
This patch allows copying tables in the binary format during table
synchronization when the binary option for a subscription is enabled.
Previously, tables are copied in text format even if the subscription is
created with the binary option enabled. Copying tables in binary format
may reduce the time spent depending on column types.
A binary copy for initial table synchronization is supported only when
both publisher and subscriber are v16 or later.
Author: Melih Mutlu
Reviewed-by: Peter Smith, Shi yu, Euler Taveira, Vignesh C, Kuroda Hayato, Osumi Takamichi, Bharath Rupireddy, Hou Zhijie
Discussion: https://postgr.es/m/CAGPVpCQvAziCLknEnygY0v1-KBtg%2BOm-9JHJYZOnNPKFJPompw%40mail.gmail.com