Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

Mihail Nikalayeu <mihailnikalayeu@gmail.com>

From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>

To: Josh Kupershmidt <schmiddy@gmail.com>

Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>, Antonin Houska <ah@cybertec.at>, Hannu Krosing <hannuk@google.com>, Sergey Sargsyan <sergey.sargsyan.2001@gmail.com>, Álvaro Herrera <alvherre@kurilemu.de>, Andres Freund <andres@anarazel.de>, Michael Paquier <michael@paquier.xyz>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Andrey Borodin <amborodin86@gmail.com>, Melanie Plageman <melanieplageman@gmail.com>

Date: 2026-04-11T16:56:00Z

Lists: pgsql-hackers

Attachments

v35-0004-Use-auxiliary-indexes-for-concurrent-index-opera.patch (application/octet-stream) patch v35-0004
v35-0005-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch (application/octet-stream) patch v35-0005
v35-0003-Add-Datum-storage-support-to-tuplestore-Extend-t.patch (application/octet-stream) patch v35-0003
v35-0002-Add-STIR-access-method-and-flags-related-to-auxi.patch (application/octet-stream) patch v35-0002
v35-0001-Add-stress-tests-for-concurrent-index-builds.patch (application/octet-stream) patch v35-0001
v35-0006-Optimize-auxiliary-index-handling.patch (application/octet-stream) patch v35-0006
v35-0007-Refresh-snapshot-periodically-during-index-valid.patch (application/octet-stream) patch v35-0007

Hi!

Rebased, including fixes related to Josh's review.

Thanks!

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Revert changes to CONCURRENTLY that "sped up" Xmin advance
- e28bb8851969 15.0 cited
VACUUM: ignore indexing operations with CONCURRENTLY
- d9d076222f5b 14.0 cited
Avoid spurious waits in concurrent indexing
- c98763bf51bf 14.0 cited