Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

From: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To: Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>
Cc: Álvaro Herrera <alvherre(at)kurilemu(dot)de>, Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Andrey Borodin <amborodin86(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Subject: Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
Date: 2025-06-21 20:32:44
Message-ID: CADzfLwVT3Y14g6Maz2y92sP2L7rPvpznt+MHM++xiy-U3XMLZQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, Sergey!

I have addressed your comments:
* skip TID scan in case of empty STIR index
* fix for critical section
* formatting
* index_create signature

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

Best regards,
Mikhail.

[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

Attachment Content-Type Size
v21-0012-Remove-PROC_IN_SAFE_IC-optimization.patch application/x-patch 21.3 KB
v21-0008-Use-auxiliary-indexes-for-concurrent-index-opera.patch application/x-patch 95.5 KB
v21-0011-Refresh-snapshot-periodically-during-index-valid.patch application/x-patch 23.3 KB
v21-0010-Optimize-auxiliary-index-handling.patch application/x-patch 2.4 KB
v21-0009-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch application/x-patch 30.5 KB
v21-0007-Add-Datum-storage-support-to-tuplestore.patch application/x-patch 19.0 KB
v21-0006-Add-STIR-access-method-and-flags-related-to-auxi.patch application/x-patch 37.4 KB
v21-0005-Support-snapshot-resets-in-concurrent-builds-of-.patch application/x-patch 39.4 KB
v21-0002-Add-stress-tests-for-concurrent-index-builds.patch application/x-patch 9.1 KB
v21-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch application/x-patch 23.2 KB
v21-0003-Reset-snapshots-periodically-in-non-unique-non-p.patch application/x-patch 46.1 KB
v21-0004-Support-snapshot-resets-in-parallel-concurrent-i.patch application/x-patch 41.2 KB
v21-only-part-3-0006-Refresh-snapshot-periodically-during.patch_ application/octet-stream 20.7 KB
v21-only-part-3-0004-Track-and-drop-auxiliary-indexes-in-.patch_ application/octet-stream 30.5 KB
v21-only-part-3-0005-Optimize-auxiliary-index-handling.patch_ application/octet-stream 2.4 KB
v21-only-part-3-0001-Add-STIR-access-method-and-flags-rel.patch_ application/octet-stream 37.4 KB
v21-only-part-3-0003-Use-auxiliary-indexes-for-concurrent.patch_ application/octet-stream 95.6 KB
v21-only-part-3-0002-Add-Datum-storage-support-to-tuplest.patch_ application/octet-stream 19.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-06-21 21:21:51 Allow the "operand" input of width_bucket() to be NaN
Previous Message Arseniy Mukhin 2025-06-21 18:54:21 Re: [PATCH] pg_bsd_indent: improve formatting of multiline comments