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

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Add support for COPY TO in tablesync for partitioned tables.
Дата
Msg-id CAA4eK1LQmAA2VHpygJ7PtrWEChW-Zvk44fA-ecqmCPOPah21yQ@mail.gmail.com
обсуждение исходный текст
Ответ на Add support for COPY TO in tablesync for partitioned tables.  (Ajin Cherian <itsajin@gmail.com>)
Ответы Re: Add support for COPY TO in tablesync for partitioned tables.
Список pgsql-hackers
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 по дате отправления: