Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
Mikhail Nikalayeu <mihailnikalayeu@gmail.com>
From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
To: Michail Nikolaev <michail.nikolaev@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-02-20T14:56:20Z
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
- v15-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch (text/x-patch) patch v15-0005
- v15-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch (text/x-patch) patch v15-0001
- v15-0002-Add-stress-tests-for-concurrent-index-operations.patch (text/x-patch) patch v15-0002
- v15-0003-Allow-advancing-xmin-during-non-unique-non-paral.patch (text/x-patch) patch v15-0003
- v15-0004-Allow-snapshot-resets-during-parallel-concurrent.patch (text/x-patch) patch v15-0004
- v15-0006-Add-STIR-Short-Term-Index-Replacement-access-met.patch (text/x-patch) patch v15-0006
- v15-0007-tuplestore-add-support-for-storing-Datum-values.patch (text/x-patch) patch v15-0007
- v15-0008-Improve-CREATE-REINDEX-INDEX-CONCURRENTLY-using-.patch (text/x-patch) patch v15-0008
- v15-0009-Concurrently-built-index-validation-uses-fresh-s.patch (text/x-patch) patch v15-0009
- v15-0011-Add-proper-handling-of-auxiliary-indexes-during-.patch (text/x-patch) patch v15-0011
- v15-0012-Updates-index-insert-and-value-computation-logic.patch (text/x-patch) patch v15-0012
- v15-0010-Remove-PROC_IN_SAFE_IC-optimization.patch (text/x-patch) patch v15-0010
Hello, everyone. Just rebased. Also, this is Discord thread: https://discordapp.com/channels/1258108670710124574/1259884843165155471/1334565506149253150