MIME-Version: 1.0
References: 
 <CAAAe_zA3vXEPkC7=fapx0VCE5F2uSgRjKjur67Yfd+JxtWPCuQ@mail.gmail.com>
 <20260427.174220.1939160662649810289.ishii@postgresql.org>
 <CAAAe_zBdwAUDNs_WFdLkFF=ewhkDkv-AqizVEVzhsfremGFb4w@mail.gmail.com>
 <20260502.131718.1177156404282376744.ishii@postgresql.org>
In-Reply-To: <20260502.131718.1177156404282376744.ishii@postgresql.org>
Reply-To: assam258@gmail.com
From: Henson Choi <assam258@gmail.com>
Date: Sat, 2 May 2026 13:30:25 +0900
Message-ID: 
 <CAAAe_zCe1gj_UkapC4e_GVZmud+dxru8YONpKRhtY6c2RmXcZg@mail.gmail.com>
Subject: Re: Row pattern recognition
To: Tatsuo Ishii <ishii@postgresql.org>
Cc: zsolt.parragi@percona.com, sjjang112233@gmail.com,
 vik@postgresfriends.org,
	er@xs4all.nl, jacob.champion@enterprisedb.com, david.g.johnston@gmail.com,
	peter@eisentraut.org, li.evan.chao@gmail.com, pgsql-hackers@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c097ec0650ce2805"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAAe_zCe1gj_UkapC4e_GVZmud%2Bdxru8YONpKRhtY6c2RmXcZg%40mail.gmail.com>
Precedence: bulk

--000000000000c097ec0650ce2805
Content-Type: text/plain; charset="UTF-8"

Hi Tatsuo,

I know in v47 JIT compilation supports PREV/NEXT. What about
> FIRST/LAST and compound forms?
>

Yes, those are JIT-compiled too in v47.

The JIT side only deals with two opcodes -- EEOP_RPR_NAV_SET
and EEOP_RPR_NAV_RESTORE.

FIRST/LAST and the compound forms differ only in how
ExecEvalRPRNavSet() computes target_pos for the slot swap;
the opcode interface and the call into ExecEvalRPRNavSet /
ExecEvalRPRNavRestore are unchanged.

So 0018's JIT support carries over to FIRST/LAST and
compounds without any JIT-side change.

Regards,
Henson

--000000000000c097ec0650ce2805
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi Tatsuo,<br></div><br><div class=3D"gma=
il_quote gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex">I know in v47 JIT compilation supports PREV/NEXT. What about<br>
FIRST/LAST and compound forms?<br></blockquote><div><br></div><div>Yes, tho=
se are JIT-compiled too in v47.<br><br>The JIT side only deals with two opc=
odes -- EEOP_RPR_NAV_SET<br>and EEOP_RPR_NAV_RESTORE.<br><br>FIRST/LAST and=
 the compound forms differ only in how<br>ExecEvalRPRNavSet() computes targ=
et_pos for the slot swap;<br>the opcode interface and the call into ExecEva=
lRPRNavSet /<br>ExecEvalRPRNavRestore are unchanged.<br><br>So 0018&#39;s J=
IT support carries over to FIRST/LAST and<br>compounds without any JIT-side=
 change.<br><br></div><div>Regards,<br></div><div>Henson</div></div></div>

--000000000000c097ec0650ce2805--