pgsql: Use "COPY table TO" for partitioned tables in initial table sync

From: Masahiko Sawada <msawada(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Use "COPY table TO" for partitioned tables in initial table sync
Date: 2025-11-20 22:51:52
Message-ID: E1vMDVH-000XaQ-1u@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Use "COPY table TO" for partitioned tables in initial table synchronization.

Commit 4bea91f added support for "COPY table TO" with partitioned
tables. This commit enhances initial table synchronization in logical
replication to use "COPY table TO" for partitioned tables if possible,
instead of "COPY (SELECT ...) TO" variant, improving performance.

Author: Ajin Cherian <itsajin(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAFPTHDY=w+xmEof=yyjhbDzaLxhBkoBzKcksEofXcT6EcjMbtQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/266543a62055541ddefe4e66797e0e1e4aa8705a

Modified Files
--------------
src/backend/replication/logical/tablesync.c | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Nathan Bossart 2025-11-20 23:09:31 Re: pgsql: Teach DSM registry to ERROR if attaching to an uninitialized ent
Previous Message Melanie Plageman 2025-11-20 22:37:56 pgsql: Split PruneFreezeParams initializers to one field per line