Re: Add support for COPY TO in tablesync for partitioned tables.

2025-11-13 Thread Ajin Cherian
On Thu, Nov 13, 2025 at 8:49 AM Masahiko Sawada wrote: > > On Mon, Nov 10, 2025 at 7:37 PM Ajin Cherian wrote: > > > > On Tue, Nov 11, 2025 at 2:19 PM Amit Kapila wrote: > > > > > > In the commit message, you mentioned: "Performance tests show it's > > > faster than the COPY (SELECT ...) TO vari

Re: Add support for COPY TO in tablesync for partitioned tables.

2025-11-12 Thread Masahiko Sawada
On Mon, Nov 10, 2025 at 7:37 PM Ajin Cherian wrote: > > On Tue, Nov 11, 2025 at 2:19 PM Amit Kapila wrote: > > > > In the commit message, you mentioned: "Performance tests show it's > > faster than the COPY (SELECT ...) TO variant as it avoids the > > overheads of query processing and sending res

Re: Add support for COPY TO in tablesync for partitioned tables.

2025-11-10 Thread Ajin Cherian
On Tue, Nov 11, 2025 at 2:19 PM Amit Kapila wrote: > > In the commit message, you mentioned: "Performance tests show it's > faster than the COPY (SELECT ...) TO variant as it avoids the > overheads of query processing and sending results to the COPY TO > command.". Can you share the performance da

Re: Add support for COPY TO in tablesync for partitioned tables.

2025-11-10 Thread Amit Kapila
On Tue, Nov 11, 2025 at 8:39 AM Ajin Cherian wrote: > > After patch [1] was committed, the COPY TO command is now supported > for partitioned tables. This change updates the tablesync logic to use > COPY TO for partitioned tables as well. > In the commit message, you mentioned: "Performance tests

Add support for COPY TO in tablesync for partitioned tables.

2025-11-10 Thread Ajin Cherian
Hi all, After patch [1] was committed, the COPY TO command is now supported for partitioned tables. This change updates the tablesync logic to use COPY TO for partitioned tables as well. This change will only be invoked when the publication is configured with publish_via_partition_root = true; oth