MIME-Version: 1.0
References: 
 <CA+TgmoZ-Jh1T6QyWoCODMVQdhTUPYkaZjWztzP1En4=ZHoKPzw@mail.gmail.com>
 <CAKZiRmxtJAFG7e1+Vs9B8ngON=AOzJbuws+1ZeH4LsbJh5AzoQ@mail.gmail.com>
 <CA+TgmoZf1F360z6jNVZyv7UF=URSNvCWbsCX7A_nsH=iaEqm0A@mail.gmail.com>
In-Reply-To: 
 <CA+TgmoZf1F360z6jNVZyv7UF=URSNvCWbsCX7A_nsH=iaEqm0A@mail.gmail.com>
From: Alastair Turner <minion@decodable.me>
Date: Fri, 31 Oct 2025 21:17:41 +0000
Message-ID: 
 <CAC0GmywDf5cs1_DoCyZwec=73Q5P7t88ikJ=LuKLXPO-Fd2LFQ@mail.gmail.com>
Subject: Re: pg_plan_advice
To: Robert Haas <robertmhaas@gmail.com>
Cc: Jakub Wartak <jakub.wartak@enterprisedb.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000003433506427ae66a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAC0GmywDf5cs1_DoCyZwec%3D73Q5P7t88ikJ%3DLuKLXPO-Fd2LFQ%40mail.gmail.com>
Precedence: bulk

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

On Fri, 31 Oct 2025, 12:51 Robert Haas, <robertmhaas@gmail.com> wrote:

> On Fri, Oct 31, 2025 at 5:59=E2=80=AFAM Jakub Wartak
> <jakub.wartak@enterprisedb.com> wrote:
> > > First, any form of user control over the planner tends to be a
> lightning rod for criticism around here.
> >
> > I do not know where this is coming from, but everybody I've talked to
> > was saying this is needed to handle real enterprise databases and
> > applications. I just really love it, how one could precisely adjust
> > the plan with this even with the presence of heavy aliasing:
>

I really like the functionality of the current patch as well, even though I
am suspicious of user control over the planner. By giving concise, precise
control over a plan, this allows people who believe they can out-plan the
planner to test their alternative, and possibly fail.

Whatever other UIs and integrations you build as you develop this towards
you goal, please keep what's currently there user accessible. Not only for
testing code, but also for testing users' belief that they know better.

Alastair

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

<div dir=3D"auto"><div><br><div class=3D"gmail_quote gmail_quote_container"=
><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 31 Oct 2025, 12:51 Robert Ha=
as, &lt;<a href=3D"mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>&=
gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0=
 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Fri, Oct 31, 2025 at =
5:59=E2=80=AFAM Jakub Wartak<br>
&lt;<a href=3D"mailto:jakub.wartak@enterprisedb.com" target=3D"_blank" rel=
=3D"noreferrer">jakub.wartak@enterprisedb.com</a>&gt; wrote:<br>
&gt; &gt; First, any form of user control over the planner tends to be a li=
ghtning rod for criticism around here.<br>
&gt;<br>
&gt; I do not know where this is coming from, but everybody I&#39;ve talked=
 to<br>
&gt; was saying this is needed to handle real enterprise databases and<br>
&gt; applications. I just really love it, how one could precisely adjust<br=
>
&gt; the plan with this even with the presence of heavy aliasing:<br></bloc=
kquote></div></div><div dir=3D"auto"><br></div><div dir=3D"auto">I really l=
ike the functionality of the current patch as well, even though I am suspic=
ious of user control over the planner. By giving concise, precise control o=
ver a plan, this allows people who believe they can out-plan the planner to=
 test their alternative, and possibly fail.=C2=A0</div><div dir=3D"auto"><b=
r></div><div dir=3D"auto">Whatever other UIs and integrations you build as =
you develop this towards you goal, please keep what&#39;s currently there u=
ser accessible. Not only for testing code, but also for testing users&#39; =
belief that they know better.=C2=A0</div><div dir=3D"auto"><br></div><div d=
ir=3D"auto">Alastair=C2=A0</div></div>

--00000000000003433506427ae66a--