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

Amit Kapila <amit.kapila16@gmail.com>

From: Amit Kapila <amit.kapila16@gmail.com>

To: Ajin Cherian <itsajin@gmail.com>

Cc: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>

Date: 2025-11-11T03:18:58Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Use "COPY table TO" for partitioned tables in initial table synchronization.
- 266543a62055 19 (unreleased) landed
Support COPY TO for partitioned tables.
- 4bea91f21f61 19 (unreleased) cited

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.