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

Ajin Cherian <itsajin@gmail.com>

From: Ajin Cherian <itsajin@gmail.com>

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

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

Date: 2025-11-11T03:37:01Z

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 2:19 PM Amit Kapila <amit.kapila16@gmail.com> 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 data to substantiate this
> point?
>

This was based on the tests done in the original thread [1] and [2]

[1]- https://www.postgresql.org/message-id/174219852967.294107.6195385625494034792.pgcf%40coridan.postgresql.org
[2]- https://www.postgresql.org/message-id/CALdSSPi5GUx1XtVTEOmvZ73MDM9HrpzE7L_Dp55z30wfp7KMvw%40mail.gmail.com

regards,
Ajin Cherian
Fujitsu Australia