Date: Tue, 9 Jun 2020 10:36:31 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Andrey Klychkov <aaklychkov@mail.ru>,
	Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
	pgsql-bugs@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: 
Message-ID: <20200609013631.GA3326@paquier.xyz>
References: <1590581418.481387288@f493.i.mail.ru>
 <20200608173707.GA18596@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="k+w/mQv8wyuph6w0"
Content-Disposition: inline
In-Reply-To: <20200608173707.GA18596@alvherre.pgsql>
Precedence: bulk


--k+w/mQv8wyuph6w0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--k+w/mQv8wyuph6w0
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl7e558ACgkQnvQgOdby
QH16WBAAo+/in7WJv3y3WDpCT+u2CLlK4szuqNASp6r5TZY+KSvhlmsrvAJMetAO
HU6z7tY2N82OzKW9q3Xe7vAeDtaj4IZm73FQFXOAyeQfAJnOIoUoMl9x6WYuvALu
fQzB/WUQPXEO7N9mXbTD6iQ/MWNLIaI6V+/CQsaE7NZL0JSIxpqnFY6CPjN/Ui1x
aabRjlFCfYuKe9C7/TnkTQ2gPX/OcjgIuhfZm45xcezkT6zTfuzXH2V+5E5lwfbt
/iva84Km9Qxhz5VswP0EJRxeksRgaz12Xzn8aS7SqC9r7xszrYQPqeVMzjcutZWD
c3okn+0THqLxGKJwcW5meDQyBykSgocPzdO7dBqjg66LE3WhFbLr6Qd1LFdQY88I
EesdcMFjCdZmdoeMEWaj+eC0kZEZRRGQrX429DK4s3l/xpu0ZneGOxInCAOpovoq
LO3hiCmOOnP2sEAxQZBwWtHlsz1QiJu9iXnzWBpaIiw1KUx1HsSmju/e/KfgrN7c
ty2Z04r70AUeFWuaD7Vbv9NAfLeaNhg+MLEi0DDSjOQhoF7TCAYC4Lk9bbfKTHAB
J9gTqaSQOyUP+lhrytjdC5b7+CXA+DRXGl02EixG17ixsjR7/2VQPhEQhlucVkHj
p4P+BoFwuchSfCM1izWGAODC7KVnCRqG4nxidlCWjSTPrzCTR6Y=
=QcxK
-----END PGP SIGNATURE-----

--k+w/mQv8wyuph6w0--