public inbox for [email protected]  

help / color / mirror / Atom feed

From: Peter Geoghegan <[email protected]>
To: Andres Freund <[email protected]>
Cc: Matthias van de Meent <[email protected]>
Cc: Andrew Dunstan <[email protected]>
Cc: Melanie Plageman <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: Konstantin Knizhnik <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: Alexander Kuzmenkov <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Heikki Linnakangas <[email protected]>
Subject: Re: Incorrect result of bitmap heap scan.
Date: Mon, 2 Dec 2024 15:59:36 -0500
Message-ID: <CAH2-WznOtpQ=Pb7cO2ppigR+UDpTTuRUmiND042mwM1P3pdLNw@mail.gmail.com> (raw)
In-Reply-To: <CAH2-Wzm6gBqc99iEKO6540ynwpjOqWESt5yjg-bHbt0hc8DPsw@mail.gmail.com>
References: <[email protected]>
	<CAEze2Wg1Q4gWzm9RZ0yXydm23Mj3iScu8LA__Zz3JJEgpnoGPQ@mail.gmail.com>
	<vdoqkxlh3apghactvvfw6ftgeog4hqnc5sinudx2qj4kbxyab4@sk6nalz5xxti>
	<4vhpxjxmwedmnly6tm7i3rwwvqhzax6uf5g7dxvkixj252mbth@3l2h2kpnw4p5>
	<CAH2-Wzm6gBqc99iEKO6540ynwpjOqWESt5yjg-bHbt0hc8DPsw@mail.gmail.com>

On Mon, Dec 2, 2024 at 3:56 PM Peter Geoghegan <[email protected]> wrote:
> I took what you wrote, and repurposed it to prove my old theory about
> GiST index-only scans being broken due to the lack of an appropriate
> interlock against concurrent TID recycling. See the attached patch.

BTW, if you change the test case to use the default B-Tree index AM
(by removing "USING GIST"), you'll see that VACUUM blocks on acquiring
a cleanup lock (and so the test just times out). The problem is that
GiST VACUUM just doesn't care about cleanup locks/TID recycling safety
-- though clearly it should.

-- 
Peter Geoghegan

view thread (19+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Incorrect result of bitmap heap scan.
  In-Reply-To: <CAH2-WznOtpQ=Pb7cO2ppigR+UDpTTuRUmiND042mwM1P3pdLNw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox