Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Петър Славов <pet.slavov@gmail.com>

Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Date: 2022-05-19T08:02:32Z

Lists: pgsql-bugs

On Thu, May 19, 2022 at 08:24:27AM +0300, Петър Славов wrote:
> Yes I have made the same test on PostgreSQL 13.7, but the reindex works as
> expected there (no issues).
> I haven't  tested on older versions.

Okay, thanks.  Something that has changed in this area is the
addition of c98763b, where spurious waits are avoided in some of the
phaese of REINDEX CONCURRENTLY.  I am wondering if this is related.
--
Michael

Commits

Revert changes to CONCURRENTLY that "sped up" Xmin advance
- e28bb8851969 15.0 landed
- 042b584c7f7d 14.4 landed
Fix possible HOT corruption when RECENTLY_DEAD changes to DEAD while pruning.
- 18b87b201f73 15.0 cited