Re: [SP-]GiST IOS visibility bug (was: Why doens't GiST require super-exclusive lock)

From: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To: solai v <solai(dot)cdac(at)gmail(dot)com>
Cc: Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Subject: Re: [SP-]GiST IOS visibility bug (was: Why doens't GiST require super-exclusive lock)
Date: 2026-07-29 17:01:00
Message-ID: CADzfLwW1q8Feyk7UsEiszn0DAUDv0+ipvgq1T7kLwb2R-E_vvw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

I am working on a stress-test framework and was trying to use it to
reproduce this bug.
It reproduced, but SP-GiST failed after the fix was applied.

AI tool decided the issue was caused by a problem in the patch; the
AI-crafted fix is attached.
I haven't validated it carefully, sorry, but I think it will be helpful.

Best regards,
Mikhail.

Attachment Content-Type Size
nocfbot_spgistvischeckwrongtid.patch text/x-patch 491 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2026-07-29 17:07:08 Re: tablecmds: fix bug where index rebuild loses replica identity on partitions
Previous Message Masahiko Sawada 2026-07-29 16:53:16 Re: Fix stale comment in parallel_vacuum_main().