Re: Let an ordering index scan hand its ORDER BY value to the target list

From: Greg Burd <greg(at)burd(dot)me>
To: Oleg Bartunov <obartunov(at)postgrespro(dot)ru>
Cc: Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Chris Cleveland <ccleveland(at)dieselpoint(dot)com>
Subject: Re: Let an ordering index scan hand its ORDER BY value to the target list
Date: 2026-11-14 13:14:21
Message-ID: avheVK0rcdmjGOOg@werk
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

v14 attached, rebased over f14a16c28bc. That commit added an ojrelids
field to JoinPathExtraData next to where 0007 adds extras_outer and
extras_inner, so v13's 0007 no longer applied and cfbot marked the entry
as needing a rebase. 0007 keeps both fields. Nothing else changed: the
patches are the same as v13 apart from context.

The series applies to master as of 77bba5454f9.

best.

-greg

Attachment Content-Type Size
v14-0005-Don-t-charge-an-index-only-scan-for-index-expres.patch text/x-patch 8.6 KB
v14-0001-Compute-the-distance-between-a-point-and-a-box-e.patch text/x-patch 22.5 KB
v14-0004-Let-an-ordering-index-scan-below-a-join-emit-its.patch text/x-patch 20.1 KB
v14-0006-Let-an-index-only-scan-win-on-the-index-expressi.patch text/x-patch 14.7 KB
v14-0003-Don-t-charge-an-ordering-index-scan-for-ORDER-BY.patch text/x-patch 24.1 KB
v14-0008-Carry-index-computed-values-through-outer-joins-.patch text/x-patch 55.3 KB
v14-0002-Let-an-ordering-index-scan-hand-its-ORDER-BY-val.patch text/x-patch 61.8 KB
v14-0007-Carry-index-computed-values-up-through-joins-and.patch text/x-patch 89.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Burd 2026-11-14 13:50:49 Re: ZSTD TOAST compression, and an extensible compression method encoding
Previous Message Zhijie Hou 2026-11-14 13:08:18 Re: WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts