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

Commits on Mar 21, 2025

  1. Use streaming read I/O in btree vacuuming 

    Btree vacuum processes all index pages in physical order. Now it uses
the read stream API to get the next buffer instead of explicitly
invoking ReadBuffer().

It is possible for concurrent indexes to cause page splits during index
vacuuming. This can lead to index entries that have yet to be vacuumed
being moved to pages that have already been vacuumed. Btree vacuum code
handles this by backtracking to reprocess those pages. So, while normal,
sequentially encountered pages are now read through the read stream API,
backtracked pages are still read with explicit ReadBuffer() calls.

Author: Andrey Borodin <[email protected]>
Reviewed-by: Melanie Plageman <[email protected]>
Reviewed-by: Junwang Zhao <[email protected]>
Reviewed-by: Kirill Reshke <[email protected]>
Discussion: https://postgr.es/m/flat/CAAKRu_bW1UOyup%3DjdFw%2BkOF9bCaAm%3D9UpiyZtbPMn8n_vnP%2Big%40mail.gmail.com#3b3a84132fc683b3ee5b40bc4c2ea2a5
    @melanieplageman
    melanieplageman authored and Commitfest Bot committed Mar 21, 2025
    Configuration menu
    Copy the full SHA
    fcfa5db View commit details
    Browse the repository at this point in the history

  2. test backtrack

    @melanieplageman
    melanieplageman authored and Commitfest Bot committed Mar 21, 2025
    Configuration menu
    Copy the full SHA
    4e1bb8e View commit details
    Browse the repository at this point in the history

  3. [CF 5327] v10 - Use read_stream in index vacuum 

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

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

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/CAAKRu_YeMT67LfyN7siwiACP9Q7YnCY9zdzxbv1Rhkeg94mYSQ@mail.gmail.com
Author(s): Andrey Borodin
    Commitfest Bot committed Mar 21, 2025
    Configuration menu
    Copy the full SHA
    ba7c386 View commit details
    Browse the repository at this point in the history
Loading