Feedback-ID: i0fe9450f:Fastmail
Date: Thu, 26 May 2022 12:39:20 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Bruce Momjian <bruce@momjian.us>
Cc: Peter Geoghegan <pg@bowt.ie>, Robert Haas <robertmhaas@gmail.com>,
	Alvaro Herrera <alvherre@alvh.no-ip.org>,
	Andres Freund <andres@anarazel.de>,
	Andrey Borodin <x4mmm@yandex-team.ru>,
	=?utf-8?B?0J/QtdGC0YrRgCDQodC70LDQstC+0LI=?= <pet.slavov@gmail.com>,
	PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17485: Records missing from Primary Key index when doing
 REINDEX INDEX CONCURRENTLY
Message-ID: <Yo72aOILTPjBldWU@paquier.xyz>
References: 
 <CA+TgmoYP7BnHXTEoJRUnOuie2J05Qo8ti5mnE2u-1c4Hk+8zJw@mail.gmail.com>
 <202205251643.2py5jjpaw7wy@alvherre.pgsql>
 <CA+TgmobNBHAObYS1yeX6C+Ph3ccborF86t9XFERdvtmmu-5DMg@mail.gmail.com>
 <CAH2-Wz=cDCzrfwm8YYF4vd8oMNJtVRh+_BbCqhCrKzX1NgXzQw@mail.gmail.com>
 <Yo7xTUr3eNgxuBq4@momjian.us>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="bq6lvTW57VVLlmtO"
Content-Disposition: inline
In-Reply-To: <Yo7xTUr3eNgxuBq4@momjian.us>
Archived-At: 
 <https://www.postgresql.org/message-id/Yo72aOILTPjBldWU%40paquier.xyz>
Precedence: bulk


--bq6lvTW57VVLlmtO
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Wed, May 25, 2022 at 11:17:33PM -0400, Bruce Momjian wrote:
> *  Caused by CREATE/REINDEX CONCURRENTLY

Yes.

> *  No way to detect which indexes were created concurrently
> *  amcheck will be required to find corrupt indexes (options?)

amcheck would help for btree, not the other AMs.  I am not sure but
there could be other symptoms that may not be detected by amcheck?

> *  Heap is fine, only index is corrupt

Yes.

> *  Bug since PG 14

14.0, yes.

> *  Not known why reports are only appearing now
> *  Feature will likely need to be removed rather than fixed

Trends go in this direction.  It does not seem like there is a
complete conclusion on this point, either.
--
Michael

--bq6lvTW57VVLlmtO
Content-Type: application/pgp-signature; name="signature.asc"

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmKO9mgACgkQnvQgOdby
QH1Ffg/+NedEjxgYP/YamWN+JqaGlMK0V3VRfN8qkD4u3ea1EC9NqU1qjr28h+rC
OMRCYNw5xAPGXO4mfh1CmHqFyfeUpvgtY2Emn56/82ug/rVzImQVNMkzjowEs/nA
np6PlzkodPntfC/X+Su7yXBrINixET1pO6WBKAczqlht9jAW1g4h2rkC2N+Fx87H
mHDjOabHbMfuCE6HcVcdgEnd2tb8ejRb+gBpklYnj8vqH3u/9uKTigaEF1fITgtw
sUWIB58PETw8xWQanc5L5Pdjk9kOg9tF7Ztlla2NhcegGHkO0cTKlsS2etsNBybx
Q3yJFvkmEiKyPneZPssInfWGQCf7fgKZDYGN8JmdxuNUvfB+bMOSHa8Mq0K2qWhA
d1rblFk0dqd1+OJEbqlWp/BqpOaIgzCcTL6mbfJpyzoNO0Qlpnx/hYNrQm3So5X9
FvUuuRN8lRpaz3T5pb2gThsPSK3Hlxu/8sNHk8+MXt6Om3nS1B1C021cY0G6/H4K
acsQxgENxUg8SPxB9JjrU9F6SlzLq4/jvJFzXsBXfK3WPypu6ODGlMFUTmMturBB
WtS56Po+CliTeJmJGngTppUoOjPCAQeWiad8mG8d1PnmPTeTMC+ElXAjhPztG1eO
OeBzEahVv4saQ/KtQxMImhp0gV+V3y9884+NK5uuQjSxnJcNRIw=
=gGMn
-----END PGP SIGNATURE-----

--bq6lvTW57VVLlmtO--