Re: Index drops during phase 1 of REINDEX CONCURRENTLY

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Index drops during phase 1 of REINDEX CONCURRENTLY
Date: 2026-11-15 04:22:59
Message-ID: CAGRkXqRNp73TCNsuOBvSzvCumkKZ+UdMFj6c5w-xH1WSPzYYog@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Michael,

Thanks for the patch. I created the expression index first in the
new test, so concur_reindex_ddl_f() drops an index that the loop in
ReindexRelationConcurrently() has not reached yet. With the patch
the index_open() of the next iteration still fails with

ERROR: could not open relation with OID 16390

Would it make sense to open all the old indexes before the loop?

Thanks,
Shihao

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Manu 2026-11-15 04:53:47 Re: ZSTD TOAST compression, and an extensible compression method encoding
Previous Message shihao zhong 2026-11-15 04:15:47 Incremental Sort crash on a rescan that becomes bounded