agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedFrom: Álvaro Herrera <alvherre@kurilemu.de>
To: Zsolt Parragi <zsolt.parragi@percona.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: REPACK (CONCURRENTLY) doesn't handle invalid indexes
Date: Tue, 28 Jul 2026 08:16:07 +0200
Message-ID: <amhIwN9DHA1NEPxN@alvherre.pgsql> (raw)
In-Reply-To: <CAN4CZFMdc--zwTpeNvZEUa1Ae04boM7np4H4=+Z7X=JsO2DLUQ@mail.gmail.com>
On 2026-Jul-27, Zsolt Parragi wrote:
> > Wouldn't it make more sense to just ignore invalid indexes and not build
> > anything at all for them?
>
> I followed what REPACK/VACUUM FULL does - it similarly rebuilds
> invalid indexes, shouldn't we keep the two consistent?
I don't know. Maybe rebuilding invalid indexes is pointless. Don't you
think so? An invalid index can never be turned valid, so why spend
effort in building it at all?
> And by skipping you mean that we should create an empty index instead
> when repack sees an invalid index?
I mean we should just ignore all invalid indexes.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"¿Cómo puedes confiar en algo que pagas y que no ves,
y no confiar en algo que te dan y te lo muestran?" (Germán Poo)
view thread (16+ messages) latest in thread
Message-ID: <amhIwN9DHA1NEPxN@alvherre.pgsql>
Permalink: ../amhIwN9DHA1NEPxN@alvherre.pgsql/
Also on: postgresql.org/message-id/amhIwN9DHA1NEPxN@alvherre.pgsql
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@kurilemu.de, zsolt.parragi@percona.com, pgsql-bugs@lists.postgresql.org
Subject: Re: REPACK (CONCURRENTLY) doesn't handle invalid indexes
In-Reply-To: <amhIwN9DHA1NEPxN@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox