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

Commits on Jun 30, 2025

  1. Normalize variable fetch sizes in a FETCH command 

    Prior to this patch, every FETCH call would generate a unique queryId.
This led to significant bloat in pg_stat_statements, as repeatedly calling
a specific cursor would result in a new queryId each time. For example,
FETCH 1 c1; and FETCH 2 c1; would produce different queryIds.

This patch improves the situation by normalizing the fetch size, so semantically
similar statements generate the same queryId. As a result, statements like the below,
which differ syntactically but have the same effect, will now share a single queryId:

FETCH FROM c1;
FETCH NEXT c1;
FETCH 1 c1;

Discussion: https://www.postgresql.org/message-id/flat/CAA5RZ0tA6LbHCg2qSS%2BKuM850BZC_%2BZgHV7Ug6BXw22TNyF%2BMA%40mail.gmail.com
    Ubuntu authored and Commitfest Bot committed Jun 30, 2025
    Configuration menu
    Copy the full SHA
    4212465 View commit details
    Browse the repository at this point in the history

  2. [CF 5733] v6 - Improve explicit cursor handling in pg_stat_statements 

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

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

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/CAA5RZ0v8iRihm8zC8Rs3U1HzXOH8RWnY0_zf+AQNoo_WbWo2Nw@mail.gmail.com
Author(s): Sami Imseih
    Commitfest Bot committed Jun 30, 2025
    Configuration menu
    Copy the full SHA
    35c4683 View commit details
    Browse the repository at this point in the history
Loading