Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

Mikhail Nikalayeu <mihailnikalayeu@gmail.com>

From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>

To: Sergey Sargsyan <sergey.sargsyan.2001@gmail.com>

Cc: Á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>, Matthias van de Meent <boekewurm+postgres@gmail.com>

Date: 2025-09-05T00:25:56Z

Lists: pgsql-hackers

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

Attachments

v23-0009-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch (application/octet-stream) patch v23-0009
v23-0011-Refresh-snapshot-periodically-during-index-valid.patch (application/octet-stream) patch v23-0011
v23-0010-Optimize-auxiliary-index-handling.patch (application/octet-stream) patch v23-0010
v23-0008-Use-auxiliary-indexes-for-concurrent-index-opera.patch (application/octet-stream) patch v23-0008
v23-0012-Remove-PROC_IN_SAFE_IC-optimization.patch (application/octet-stream) patch v23-0012
v23-0004-Support-snapshot-resets-in-parallel-concurrent-i.patch (application/octet-stream) patch v23-0004
v23-0003-Reset-snapshots-periodically-in-non-unique-non-p.patch (application/octet-stream) patch v23-0003
v23-0006-Add-STIR-access-method-and-flags-related-to-auxi.patch (application/octet-stream) patch v23-0006
v23-0007-Add-Datum-storage-support-to-tuplestore.patch (application/octet-stream) patch v23-0007
v23-0005-Support-snapshot-resets-in-concurrent-builds-of-.patch (application/octet-stream) patch v23-0005
v23-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch (application/octet-stream) patch v23-0001
v23-only-part-3-0005-Optimize-auxiliary-index-handling.patch_ (application/octet-stream)
v23-only-part-3-0006-Refresh-snapshot-periodically-during.patch_ (application/octet-stream)
v23-only-part-3-0004-Track-and-drop-auxiliary-indexes-in-.patch_ (application/octet-stream)
v23-0002-Add-stress-tests-for-concurrent-index-builds.patch (application/octet-stream) patch v23-0002
v23-only-part-3-0003-Use-auxiliary-indexes-for-concurrent.patch_ (application/octet-stream)
v23-only-part-3-0002-Add-Datum-storage-support-to-tuplest.patch_ (application/octet-stream)
v23-only-part-3-0001-Add-STIR-access-method-and-flags-rel.patch_ (application/octet-stream)

Hello, everyone!

Rebased, patch structure and comments available here [0].
Quick introduction poster - here [1].

[0]: https://www.postgresql.org/message-id/flat/CADzfLwVOcZ9mg8gOG%2BKXWurt%3DMHRcqNv3XSECYoXyM3ENrxyfQ%40mail.gmail.com#52c97e004b8f628473124c05e3bf2da1
[1]: https://www.postgresql.org/message-id/attachment/176651/STIR-poster.pdf


Best regards,
Mikhail.