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

Commits on Nov 3, 2025

  1. bufmgr: aio: Prototype for not waiting for already-in-progress IO 

    Author:
Reviewed-by:
Discussion: https://postgr.es/m/zljergweqti7x67lg5ije2rzjusie37nslsnkjkkby4laqqbfw@3p3zu522yykv
Backpatch:
    @anarazel
    anarazel authored and Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    882792c View commit details
    Browse the repository at this point in the history

  2. Add amgetbatch interface for index scan prefetching. 

    Allows the index AM to provide items (TIDs and tuples) in batches, which
is then used to implement prefetching of heap tuples in index scans
(including index-only scans). This is similar to prefetching already
done in bitmap scans, and can result in significant speedups.

The index AM may implement an optional "amgetbatch" callback, returning
a batch of items. The indexam.c code then handles this transparently
through the existing "getnext" interface.
    @petergeoghegan
    petergeoghegan authored and Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    a1f9de1 View commit details
    Browse the repository at this point in the history

  3. Reduce malloc/free traffic by caching batches 

    Instead of immediately freeing a batch, stash it in a cache (a small
fixed-size array), for reuse by the same scan.

There's room for improvement:

- Keeping some of the batch pieces (killItems, itemsvisibility, ...)
  instead of freeing them in index_batch_release.

- Allocating only space we need (both index_batch_alloc calls use
  MaxTIDsPerBTreePage, and thus malloc - because of ALLOC_CHUNK_LIMIT).
    @petergeoghegan
    petergeoghegan authored and Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    f756662 View commit details
    Browse the repository at this point in the history

  4. [CF 4351] v20251102 - Index Prefetching 

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

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

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/CAH2-WzkHK0++yn3_nmWL2rWzXiu8Qc=2=NPQDG4nfVjvYkRDrQ@mail.gmail.com
Author(s): Peter Geoghegan, Tomas Vondra
    Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    143cbbf View commit details
    Browse the repository at this point in the history
Loading