Request a Demo
Home   >   mailing lists

Re: BUG #19082: Failing assert in index scan - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #19082: Failing assert in index scan
Date
Msg-id CAH2-Wzk4gMoxF_wpD3J9YeyjRWHr=GvruiJFkwRoZ_L0q4+_=g@mail.gmail.com
Whole thread Raw
In response to Re: BUG #19082: Failing assert in index scan  ("Matthijs van der Vleuten" <postgresql@zr40.nl>)
Responses Re: BUG #19082: Failing assert in index scan
List pgsql-bugs
Tree view 
On Fri, Oct 10, 2025 at 12:13 PM Matthijs van der Vleuten
<postgresql@zr40.nl> wrote:
> No, none of the tables and indexes in that database are unlogged or temporary.

Are these backwards scans? In other words, does EXPLAIN show "Index
Scan Backwards" for these queries? I see that the first query "ORDER
BY "mentions"."id" ASC", but perhaps that index column is declared as
DESC (in which case it'd be a backwards scan)?

--
Peter Geoghegan

pgsql-bugs by date:

Previous
From: "Matthijs van der Vleuten"
Date:
Subject: Re: BUG #19082: Failing assert in index scan
Next
From: "Matthijs van der Vleuten"
Date:
Subject: Re: BUG #19082: Failing assert in index scan