Re: Remove extra Sort node above a btree-compatible Index Scan - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Remove extra Sort node above a btree-compatible Index Scan
Date
Msg-id CAH2-WzmiiZ6214VRrhFMbvc-AOTJxxOjP0m4OYxLEnOYAc5Azg@mail.gmail.com
Whole thread Raw
In response to Remove extra Sort node above a btree-compatible Index Scan  (Alexandra Wang <alexandra.wang.oss@gmail.com>)
Responses Re: Remove extra Sort node above a btree-compatible Index Scan
List pgsql-hackers
On Fri, Feb 28, 2025 at 12:23 AM Alexandra Wang
<alexandra.wang.oss@gmail.com> wrote:
> While reviewing Mark Dilger’s patch series "Index AM API cleanup" [1],
> I noticed some unexpected plan diffs when running the xtree and treeb
> test modules. Specifically, an additional Sort node appears on top of
> an Index Only Scan, even when the index key and sort key are the same.
> For example:
>
> --- src/test/modules/xtree/expected/interval.out
> +++ src/test/modules/xtree/results/interval.out

What's the xtree module? There's no such test module?

--
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Alexandra Wang
Date:
Subject: Remove extra Sort node above a btree-compatible Index Scan
Next
From: Abhishek Chanda
Date:
Subject: Re: Adding support for SSLKEYLOGFILE in the frontend