From: Michael Paquier <michael@paquier.xyz>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Andrey Klychkov <aaklychkov@mail.ru>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-bugs@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re:
Date: Tue, 9 Jun 2020 10:36:31 +0900
Message-ID: <20200609013631.GA3326@paquier.xyz> (raw)
In-Reply-To: <20200608173707.GA18596@alvherre.pgsql>
References: <1590581418.481387288@f493.i.mail.ru>
<20200608173707.GA18596@alvherre.pgsql>
On Mon, Jun 08, 2020 at 01:37:07PM -0400, Alvaro Herrera wrote:
> I think this part remains unanswered: why are there *three* invalid
> indexes, and not two? It makes sense for the UNIQUE indexes to acquire
> invalid duplicates, but strangely we also have a
> act_re_procdef_deployment_id_idx_ccnew which is *not* unique. What
> happened there?
More than one REINDEX query at table-level failed I guess?
> (I also wonder if it wouldn't make more sense to reindexdb to attempt to
> drop indexes that it couldn't complete.)
(That's a good idea.)
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
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: michael@paquier.xyz, alvherre@2ndquadrant.com, aaklychkov@mail.ru, peter.eisentraut@2ndquadrant.com, tgl@sss.pgh.pa.us
Subject: Re:
In-Reply-To: <20200609013631.GA3326@paquier.xyz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox