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