| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Index drops during phase 1 of REINDEX CONCURRENTLY |
| Date: | 2026-11-14 00:31:36 |
| Message-ID: | aver6A1EQEd2FaKq@paquier.xyz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
Some of the feedback I got after f24a08ec13eb involved the fact that
indexes could also be dropped during the phase 1 of REINDEX
CONCURRENTLY when the expressions or predicates are evaluated. The
damage is limited to cache lookup failures or assertion hits during
phase 2, thanks to the protections that f24a08ec13eb has added.
Anyway, it would be nice to fix this issue. Attached is a patch
addressing the problem with a test, for a backpatch down to v15.
Thoughts or objections?
--
Michael
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Pin-relations-during-phase-1-of-REINDEX-CONCURRENTLY.patch | text/plain | 7.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manu | 2026-11-14 01:12:56 | Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned |
| Previous Message | Lukas Fittl | 2026-11-14 00:14:50 | Re: [BUG / PATCH] PG19: VACUUM misestimates reltuples (often 0) after on-access VM setting |