pgsql: Allow logical replication to copy tables in binary format.
От | Amit Kapila |
---|---|
Тема | pgsql: Allow logical replication to copy tables in binary format. |
Дата | |
Msg-id | E1pfBWW-004vSl-Js@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
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 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/ecb696527c01908d54b7a7aa2bd9179585b46459 Modified Files -------------- doc/src/sgml/logical-replication.sgml | 4 +- doc/src/sgml/ref/alter_subscription.sgml | 5 + doc/src/sgml/ref/create_subscription.sgml | 28 ++++- src/backend/replication/logical/tablesync.c | 17 ++- src/test/subscription/t/014_binary.pl | 180 ++++++++++++++++++++++++++-- 5 files changed, 216 insertions(+), 18 deletions(-)
В списке pgsql-committers по дате отправления: