Request a Demo
Home   >   mailing lists

Re: Add support for COPY TO in tablesync for partitioned tables. - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Add support for COPY TO in tablesync for partitioned tables.
Date
Msg-id CAA4eK1LQmAA2VHpygJ7PtrWEChW-Zvk44fA-ecqmCPOPah21yQ@mail.gmail.com
Whole thread Raw
In response to Add support for COPY TO in tablesync for partitioned tables.  (Ajin Cherian <itsajin@gmail.com>)
Responses Re: Add support for COPY TO in tablesync for partitioned tables.
List pgsql-hackers
Tree view 
On Tue, Nov 11, 2025 at 8:39 AM Ajin Cherian <itsajin@gmail.com> 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 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 data to substantiate this
point?

--
With Regards,
Amit Kapila.

pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: Make PQgetResult() not return NULL on out-of-memory error
Next
From: Chao Li
Date:
Subject: Is this a typo?