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

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Ajin Cherian <itsajin(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add support for COPY TO in tablesync for partitioned tables.
Date: 2025-11-11 03:18:58
Message-ID: CAA4eK1LQmAA2VHpygJ7PtrWEChW-Zvk44fA-ecqmCPOPah21yQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 11, 2025 at 8:39 AM Ajin Cherian <itsajin(at)gmail(dot)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.

In response to

Responses

Browse pgsql-hackers by date

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