Re: BUG #19082: Failing assert in index scan

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Matthijs van der Vleuten <postgresql(at)zr40(dot)nl>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19082: Failing assert in index scan
Date: 2025-10-10 16:28:37
Message-ID: CAH2-Wzk4gMoxF_wpD3J9YeyjRWHr=GvruiJFkwRoZ_L0q4+_=g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Oct 10, 2025 at 12:13 PM Matthijs van der Vleuten
<postgresql(at)zr40(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Matthijs van der Vleuten 2025-10-10 17:09:01 Re: BUG #19082: Failing assert in index scan
Previous Message Matthijs van der Vleuten 2025-10-10 16:12:49 Re: BUG #19082: Failing assert in index scan