Use streaming read I/O in btree vacuuming
authorMelanie Plageman <melanieplageman@gmail.com>
Fri, 21 Mar 2025 13:07:33 +0000 (09:07 -0400)
committerMelanie Plageman <melanieplageman@gmail.com>
Fri, 21 Mar 2025 13:09:39 +0000 (09:09 -0400)
commitc5c239e26e3876c05b3a2c5e8989817fd38ceed1
tree868eeae8b771dab5e4cda77f472fe35b8b858b0d
parent1d617a20284f887cb9cdfe5693eec155e8016517
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 insertions 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 sequentially encountered pages are now read through the
read stream API, backtracked pages are still read with explicit
ReadBuffer() calls.

Author: Andrey Borodin <x4mmm@yandex-team.ru>
Reviewed-by: Melanie Plageman <melanieplageman@gmail.com>
Reviewed-by: Junwang Zhao <zhjwpku@gmail.com>
Reviewed-by: Kirill Reshke <reshkekirill@gmail.com>
Discussion: https://postgr.es/m/flat/CAAKRu_bW1UOyup%3DjdFw%2BkOF9bCaAm%3D9UpiyZtbPMn8n_vnP%2Big%40mail.gmail.com#3b3a84132fc683b3ee5b40bc4c2ea2a5
src/backend/access/nbtree/nbtree.c