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
  • 4 files changed
  • 2 contributors

Commits on Apr 28, 2025

  1. support COPY partitioned_table TO 

    CREATE TABLE pp (id  int, val int ) PARTITION BY RANGE (id);
CREATE TABLE pp_1 (val int, id int);
CREATE TABLE pp_2 (val int, id int);
ALTER TABLE pp ATTACH PARTITION pp_1 FOR VALUES FROM (1) TO (5);
ALTER TABLE pp ATTACH PARTITION pp_2 FOR VALUES FROM (5) TO (10);
insert into pp select g, 10 + g from generate_series(1,9) g;
copy pp to stdout(header);

the above case is much slower (around 25% in some case) than
``COPY (select * from pp) to stdout(header);``,
because of column remaping.  but this is still a new
feature, since master does not support ``COPY (partitioned_table)``.

reivewed by: vignesh C <[email protected]>
reivewed by: David Rowley <[email protected]>
reivewed by: Melih Mutlu <[email protected]>
reivewed by: Kirill Reshke <[email protected]>

discussion: https://postgr.es/m/CACJufxEZt+G19Ors3bQUq-42-61__C=y5k2wk=sHEFRusu7=iQ@mail.gmail.com
commitfest entry: https://commitfest.postgresql.org/patch/5467/
    @jianhe-fun
    jianhe-fun authored and Commitfest Bot committed Apr 28, 2025
    Configuration menu
    Copy the full SHA
    24e206f View commit details
    Browse the repository at this point in the history

  2. [CF 5467] v10 - 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/CACJufxEp7btcpXiroNXcCvjwDwVT5-A6-A9ryWnDJiYfB7PO=Q@mail.gmail.com
Author(s): Jian He
    Commitfest Bot committed Apr 28, 2025
    Configuration menu
    Copy the full SHA
    8794f38 View commit details
    Browse the repository at this point in the history
Loading