Re: Remove extra Sort node above a btree-compatible Index Scan

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Remove extra Sort node above a btree-compatible Index Scan
Дата
Msg-id CAH2-WzmiiZ6214VRrhFMbvc-AOTJxxOjP0m4OYxLEnOYAc5Azg@mail.gmail.com
обсуждение исходный текст
Ответ на Remove extra Sort node above a btree-compatible Index Scan  (Alexandra Wang <alexandra.wang.oss@gmail.com>)
Ответы Re: Remove extra Sort node above a btree-compatible Index Scan
Список 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 по дате отправления: