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/5878~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/5878
Choose a head ref
  • 2 commits
  • 5 files changed
  • 2 contributors

Commits on Oct 30, 2025

  1. Report replica identity property of tables in pg_publication_tables 

    When debugging issues with logical replication, replica identity
property of tables in publication is often useful, for example, to
determine the amount of data logged for an UPDATE or DELETE on a table.

Given a set of publications that a WAL sender is using,
pg_publication_tables can be used to get the list of tables whose
changes will be replicated including the columns of those tables and row
filters. But the replica identity of those tables needs to be separately
found out by querying pg_class or joining pg_class with
pg_publication_tables. Adding replica identity column to
pg_publication_tables avoids this extra step.

The replica identity for a given table does not change with publication
so the information will be repeated as many times the number of
publications a given table is part of. But the repetition is worth the
convenience.

Ashutosh Bapat
    @ashutosh-bapat
    ashutosh-bapat authored and Commitfest Bot committed Oct 30, 2025
    Configuration menu
    Copy the full SHA
    bdecabc View commit details
    Browse the repository at this point in the history

  2. [CF 5878] Report replica identity in pg_publication_tables 

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

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

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/CAExHW5tbhntRpwM7Zz3CfTippVovJ_ReBt2DGyFPE8pOsDsTjw@mail.gmail.com
Author(s): Ashutosh Bapat
    Commitfest Bot committed Oct 30, 2025
    Configuration menu
    Copy the full SHA
    a0a62c2 View commit details
    Browse the repository at this point in the history
Loading