Re: Index drops during phase 1 of REINDEX CONCURRENTLY

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

On Sat, Nov 14, 2026 at 11:22:59PM -0500, shihao zhong wrote:
> Would it make sense to open all the old indexes before the loop?

Hmm, yeah. We could as well open the indexes when these are gathered
in the initial loop as we are in the same transaction. Would you like
to write a patch to show your idea? (I'm out most of next week so
won't have much time to look at what you have, but perhaps others
will.)
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zsolt Parragi 2026-11-15 07:34:48 Re: Prevent foreign key references to unlogged partitions
Previous Message Xuneng Zhou 2026-11-15 06:09:40 Re: test: avoid redundant standby catchup in 049_wait_for_lsn