Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
Mikhail Nikalayeu <mihailnikalayeu@gmail.com>
From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
To: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
Cc: alvherre@alvh.no-ip.org, 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-04-06T23:45: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
- v17-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch (application/octet-stream) patch v17-0005
- v17-0002-Add-stress-tests-for-concurrent-index-operations.patch (application/octet-stream) patch v17-0002
- v17-0003-Allow-advancing-xmin-during-non-unique-non-paral.patch (application/octet-stream) patch v17-0003
- v17-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch (application/octet-stream) patch v17-0001
- v17-0004-Allow-snapshot-resets-during-parallel-concurrent.patch (application/octet-stream) patch v17-0004
- v17-0006-Add-STIR-Short-Term-Index-Replacement-access-met.patch (application/octet-stream) patch v17-0006
- v17-0008-Improve-CREATE-REINDEX-INDEX-CONCURRENTLY-using-.patch (application/octet-stream) patch v17-0008
- v17-0007-tuplestore-add-support-for-storing-Datum-values.patch (application/octet-stream) patch v17-0007
- v17-0012-Updates-index-insert-and-value-computation-logic.patch (application/octet-stream) patch v17-0012
- v17-0009-Concurrently-built-index-validation-uses-fresh-s.patch (application/octet-stream) patch v17-0009
- v17-0010-Remove-PROC_IN_SAFE_IC-optimization.patch (application/octet-stream) patch v17-0010
- v17-0011-Add-proper-handling-of-auxiliary-indexes-during-.patch (application/octet-stream) patch v17-0011
Hello, everyone! Rebased, updated accordingly to some changes. Best regards, Mikhail.