MIME-Version: 1.0
References: <CAKqncch0vyy07-M-M5NPn7sFbQqZCnWoJfY2zF5i3mkfkzdwdQ@mail.gmail.com>
 <2087380.1724366535@sss.pgh.pa.us>
In-Reply-To: <2087380.1724366535@sss.pgh.pa.us>
From: Morris de Oryx <morrisdeoryx@gmail.com>
Date: Fri, 23 Aug 2024 09:36:21 -0500
Message-ID: <CAKqncchViX+ORtDEqxocN89ecMDZtSQ-31KmK30d=AQJcswPeA@mail.gmail.com>
Subject: Re: Is there a way to translate pg_amop.amopstrategy into a description?
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a23add06205ab336"
Archived-At: <https://www.postgresql.org/message-id/CAKqncchViX%2BORtDEqxocN89ecMDZtSQ-31KmK30d%3DAQJcswPeA%40mail.gmail.com>
Precedence: bulk

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

Thanks for the confirmation. And, I'd say that this feature would go under
"nice to have" rather than anything more important. Although, it *would *be
nice.

On Thu, Aug 22, 2024 at 5:42=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Morris de Oryx <morrisdeoryx@gmail.com> writes:
> > What I'm hoping for is a function like
> > get_opt_class_strategy_description(optclass, straregy_number)  I've
> > looked at the source a bit, and it seems that there is no such
> > function, and that it might well be difficult to implement. The
> > strategy numbers are, as far as I can see, local to the specific
> > opt_class, which has no requirement to label them in any particular
> > way.
>
> That's correct.  For btree and hash, the meanings of the strategy
> numbers are determined by the index AM; but for (IIRC) all of our
> other index AMs they're determined by the individual opclass.  So
> anything like this would have to be implemented by dedicated code
> in each opclass.  Perhaps that's worth doing, but it'd be a fair
> amount of work.
>
>                         regards, tom lane
>

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

<div dir=3D"ltr">Thanks for the confirmation. And, I&#39;d say that this fe=
ature would go under &quot;nice to have&quot; rather than anything=C2=A0mor=
e important. Although, it <i>would </i>be nice.</div><br><div class=3D"gmai=
l_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Aug 22, 2024 at 5:42=
=E2=80=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.p=
a.us</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-=
left-color:rgb(204,204,204);padding-left:1ex">Morris de Oryx &lt;<a href=3D=
"mailto:morrisdeoryx@gmail.com" target=3D"_blank">morrisdeoryx@gmail.com</a=
>&gt; writes:<br>
&gt; What I&#39;m hoping for is a function like<br>
&gt; get_opt_class_strategy_description(optclass, straregy_number)=C2=A0 I&=
#39;ve<br>
&gt; looked at the source a bit, and it seems that there is no such<br>
&gt; function, and that it might well be difficult to implement. The<br>
&gt; strategy numbers are, as far as I can see, local to the specific<br>
&gt; opt_class, which has no requirement to label them in any particular<br=
>
&gt; way.<br>
<br>
That&#39;s correct.=C2=A0 For btree and hash, the meanings of the strategy<=
br>
numbers are determined by the index AM; but for (IIRC) all of our<br>
other index AMs they&#39;re determined by the individual opclass.=C2=A0 So<=
br>
anything like this would have to be implemented by dedicated code<br>
in each opclass.=C2=A0 Perhaps that&#39;s worth doing, but it&#39;d be a fa=
ir<br>
amount of work.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--000000000000a23add06205ab336--