Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/5467~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/5467
Choose a head ref
  • 2 commits
  • 9 files changed
  • 2 contributors

Commits on Oct 19, 2025

  1. Support COPY TO for partitioned tables. 

    Previously, COPY TO command didn't support directly specifying
partitioned tables so users had to use COPY (SELECT ...) TO variant.

This commit adds direct COPY TO support for partitioned
tables, improving both usability and performance. 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.

When used with partitioned tables, COPY TO copies the same rows as
SELECT * FROM table. Row-level security policies of the partitioned
table are applied in the same way as when executing COPY TO on a plain
table.

Author: jian he <[email protected]>
Reviewed-by: vignesh C <[email protected]>
Reviewed-by: David Rowley <[email protected]>
Reviewed-by: Melih Mutlu <[email protected]>
Reviewed-by: Kirill Reshke <[email protected]>
Reviewed-by: Atsushi Torikoshi <[email protected]>
Reviewed-by: Álvaro Herrera <[email protected]>
Reviewed-by: Masahiko Sawada <[email protected]>
Reviewed-by: Chao Li <[email protected]>
Discussion: https://postgr.es/m/CACJufxEZt%2BG19Ors3bQUq-42-61__C%3Dy5k2wk%3DsHEFRusu7%3DiQ%40mail.gmail.com
    @jianhe-fun
    jianhe-fun authored and Commitfest Bot committed Oct 19, 2025
    Configuration menu
    Copy the full SHA
    1de2d0e View commit details
    Browse the repository at this point in the history

  2. [CF 5467] v20 - speedup COPY TO for partitioned table 

    This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/5467

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/CAD21AoDtx8zdzww8z-aQStLocB7mxM3UCzJyBohFYHaVg0-Z-w@mail.gmail.com
Author(s): Jian He
    Commitfest Bot committed Oct 19, 2025
    Configuration menu
    Copy the full SHA
    9bb9443 View commit details
    Browse the repository at this point in the history
Loading