Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
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/5299~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/5299
Choose a head ref
  • 2 commits
  • 3 files changed
  • 2 contributors

Commits on May 30, 2025

  1. Avoid full parallel btree index scans in skip scans 

    Previously, we could ignore the skip signal until the end of the range of
values producable by the index scan key. Now, we can fail to start a new
primscan only for up to number of parallel workers + 1 buffers, at the
cost of processing a full page before we release the parallel scan if
we detect that we may have overshot our previous skip scan's range with
the next startpoint not close in sight.

If we detect that a parallel worker in the same primscan range thinks
this is the right moment to start a new primitive scan, we don't release
the parallel scan immediately, but instead only release it after reading
the pages contents to find out if we really should start a new primitive
scan.  If so, we start that new primitive scan, and if instead we find
we've already skidded into the range of pages we would've arrived on with
the skip scan, we instead mark that the primitive scan has reached a new
primscan range, do some cleanup, and then continue the scan as usual.
    @MMeent
    MMeent authored and Commitfest Bot committed May 30, 2025
    Configuration menu
    Copy the full SHA
    4b7e005 View commit details
    Browse the repository at this point in the history

  2. [CF 5299] v2 - Limiting overshoot in nbtree SAOP parallel index scans 

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

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

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/CAEze2WhGmVWc6KBYgnE0Up=1eFr3_m2Enma1qhbs+wwzs3Xv5A@mail.gmail.com
Author(s): Matthias van de Meent
    Commitfest Bot committed May 30, 2025
    Configuration menu
    Copy the full SHA
    23d3143 View commit details
    Browse the repository at this point in the history
Loading