Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
Mihail Nikalayeu <michail.nikolaev@gmail.com>
From: Michail Nikolaev <michail.nikolaev@gmail.com>
To: Matthias van de Meent <boekewurm+postgres@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
Andrey Borodin <amborodin86@gmail.com>, Melanie Plageman <melanieplageman@gmail.com>
Date: 2024-12-21T18:00:01Z
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
- v7-0001-this-is-https-commitfest.postgresql.org-50-5160-m.patch (application/octet-stream) patch v7-0001
- v7-0003-Allow-advancing-xmin-during-non-unique-non-parall.patch (application/octet-stream) patch v7-0003
- v7-0002-Add-stress-tests-for-concurrent-index-operations.patch (application/octet-stream) patch v7-0002
- v7-0004-Allow-snapshot-resets-during-parallel-concurrent-.patch (application/octet-stream) patch v7-0004
- v7-0005-Allow-snapshot-resets-in-concurrent-unique-index-.patch (application/octet-stream) patch v7-0005
- v7-0006-Add-STIR-Short-Term-Index-Replacement-access-meth.patch (application/octet-stream) patch v7-0006
Hello! Added STIR access method, next step is validating indexes using it. Best regards, Mikhail. >