| From: | Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> |
|---|---|
| To: | Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
| Cc: | Josh Kupershmidt <schmiddy(at)gmail(dot)com>, Antonin Houska <ah(at)cybertec(dot)at>, Hannu Krosing <hannuk(at)google(dot)com>, Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>, Á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> |
| Subject: | Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements |
| Date: | 2026-08-08 15:03:00 |
| Message-ID: | CADzfLwX=2L2kLeyBjziAbA05Y+XeMSDzBMxGJk=eo4K9m8CKKw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello!
This is v38 - now STIR uses multiple pages to reduce lock contention.
Also, snapshot resetting (0007) adapter according to your comments in
another CIC-related patch.
I am not very convinced in that version yet, but decided to sent if you'll
would like to review anything.
Best regards,
Mikhail.
| Attachment | Content-Type | Size |
|---|---|---|
| v38-0005-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch | application/x-patch | 38.0 KB |
| v38-0006-Optimize-auxiliary-index-handling.patch | application/x-patch | 3.0 KB |
| v38-0007-Refresh-snapshot-periodically-during-index-valid.patch | application/x-patch | 35.1 KB |
| v38-0004-Use-auxiliary-indexes-for-concurrent-index-opera.patch | application/x-patch | 104.2 KB |
| v38-0003-Add-Datum-storage-support-to-tuplestore.patch | application/x-patch | 23.1 KB |
| v38-0001-Add-stress-tests-for-concurrent-index-builds.patch | application/x-patch | 12.6 KB |
| v38-0002-Add-STIR-access-method-and-validate_index-flag-i.patch | application/x-patch | 38.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre Forstmann | 2026-08-08 15:33:16 | Re: [PATCH] Use wait_classes.h in pg_prewarm |
| Previous Message | Virender Singla | 2026-08-08 14:46:28 | Allow pg_read_all_stats to read replication origin status |