public inbox for [email protected]  

help / color / mirror / Atom feed

From: Peter Geoghegan <[email protected]>
To: Mark Dilger <[email protected]>
Cc: Matthias van de Meent <[email protected]>
Cc: [email protected]
Subject: Re: pgsql: Improve nbtree skip scan primitive scan scheduling.
Date: Wed, 30 Apr 2025 16:25:17 -0400
Message-ID: <CAH2-WzkLSMvgGVTbj0g-1yHoQd8X2pjMAQgqjssJd3VBxmNhXw@mail.gmail.com> (raw)
In-Reply-To: <CAHgHdKsn2W=gPBmj7p6MjQFvxB+zZDBkwTSg0o3f5Hh8rkRrsA@mail.gmail.com>
References: <[email protected]>
	<CAHgHdKtLFWZcjr87hMH0hYDHgcifu4Tj7iHz-xh8qsJREt5cqA@mail.gmail.com>
	<CAH2-Wz=1eJZMSMoACDW2oLcxd8QUtKQS7HuYtqx98LLji+WKuQ@mail.gmail.com>
	<CAHgHdKuWD2h3n6MHv2SOp8VLcKsKM1R+tLBHZrnE_WDOmDaqPg@mail.gmail.com>
	<CAH2-WzmDF0Rcnvi2vhhYwLdF5bcs=8+rvScXWieBVkR2kezn6Q@mail.gmail.com>
	<CAHgHdKsn2W=gPBmj7p6MjQFvxB+zZDBkwTSg0o3f5Hh8rkRrsA@mail.gmail.com>

On Wed, Apr 30, 2025 at 4:11 PM Mark Dilger
<[email protected]> wrote:
> A similar assertion can still be reached on HEAD using the attached (rather contrived) regression test as of f60420cff66a9089a9b431f9c07f4a29aae4990a:

I independently found the same bug just a few hours ago, using an
enhanced version of my python fuzzing script (posted to the main skip
scan thread) that now performs backwards scans. I'm not at all
surprised to see that your repro also uses ORDER BY ... DESC.

Would you post to that other thread going forward, rather than posting
to this -committers thread?

I'm going to talk about this on the main skip scan -hackers thread,
when I have a proper fix. I already have a fix for the issue that you
reported, but there seems to be an independent remaining issue with
backwards scans that I haven't quite got to the bottom of just yet.

Thanks
-- 
Peter Geoghegan

view thread (7+ messages)

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]
  Subject: Re: pgsql: Improve nbtree skip scan primitive scan scheduling.
  In-Reply-To: <CAH2-WzkLSMvgGVTbj0g-1yHoQd8X2pjMAQgqjssJd3VBxmNhXw@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