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-10-28T18:37:00Z
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
- v25-0007-Add-Datum-storage-support-to-tuplestore.patch (text/x-patch) patch v25-0007
- v25-0012-Remove-PROC_IN_SAFE_IC-optimization.patch (text/x-patch) patch v25-0012
- v25-0011-Refresh-snapshot-periodically-during-index-valid.patch (text/x-patch) patch v25-0011
- v25-0010-Optimize-auxiliary-index-handling.patch (text/x-patch) patch v25-0010
- v25-0009-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch (text/x-patch) patch v25-0009
- v25-0008-Use-auxiliary-indexes-for-concurrent-index-opera.patch (text/x-patch) patch v25-0008
- v25-0004-Support-snapshot-resets-in-parallel-concurrent-i.patch (text/x-patch) patch v25-0004
- v25-0006-Add-STIR-access-method-and-flags-related-to-auxi.patch (text/x-patch) patch v25-0006
- v25-0003-Reset-snapshots-periodically-in-non-unique-non-p.patch (text/x-patch) patch v25-0003
- v25-0005-Support-snapshot-resets-in-concurrent-builds-of-.patch (text/x-patch) patch v25-0005
- v25-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch (text/x-patch) patch v25-0001
- v25-0002-Add-stress-tests-for-concurrent-index-builds.patch (text/x-patch) patch v25-0002
Fixed and assert caused https://cirrus-ci.com/task/4890065790304256?logs=test_world#L157 to fail.