MIME-Version: 1.0
References: <VisenaEmail.38.c31ee0594849fa9d.1903fc67a71@origo-test01.app.internal.visena.net>
In-Reply-To: <VisenaEmail.38.c31ee0594849fa9d.1903fc67a71@origo-test01.app.internal.visena.net>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Sat, 22 Jun 2024 20:25:29 +0530
Message-ID: <CAM+6J94tfLrHT93SnHM25WRfmd35bAP8xkAUMzZ_JWJERXvqRw@mail.gmail.com>
Subject: Re: AI for query-planning?
To: Andreas Joseph Krogh <andreas@visena.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d29a49061b7bbdc7"
Archived-At: <https://www.postgresql.org/message-id/CAM%2B6J94tfLrHT93SnHM25WRfmd35bAP8xkAUMzZ_JWJERXvqRw%40mail.gmail.com>
Precedence: bulk

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

On Sat, Jun 22, 2024, 5:20=E2=80=AFPM Andreas Joseph Krogh <andreas@visena.=
com>
wrote:

> Hi, are there any plans for using some kind of AI for query-planning?
>
> Can someone with more knowledge about this than I have please explain why
> it might, or not, be a good idea, and what the challenges are?
>

https://github.com/ossc-db/pg_plan_advsr

https://github.com/s-hironobu/pg_plan_inspector

not totally ai, but it can use data from your database to build some
metadata.

there are also plan analyzers online which people paste their plan to get a
quick summary of problem areas, that data can be useful too for ai based
plan optimisers.

but that said, postgresql has a lot of knobs to tune, so ...

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

<div dir=3D"auto"><br><br><div class=3D"gmail_quote" dir=3D"auto"><div dir=
=3D"ltr" class=3D"gmail_attr">On Sat, Jun 22, 2024, 5:20=E2=80=AFPM Andreas=
 Joseph Krogh &lt;<a href=3D"mailto:andreas@visena.com">andreas@visena.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"><p>Hi, are there any=
 plans for using some kind of AI for query-planning?</p><p>Can someone with=
 more knowledge about this than I have please explain why it might, or not,=
 be a good idea, and what the challenges are?</p></blockquote></div><div di=
r=3D"auto"><br></div><div dir=3D"auto"><a href=3D"https://github.com/ossc-d=
b/pg_plan_advsr">https://github.com/ossc-db/pg_plan_advsr</a><br></div><div=
 dir=3D"auto"><br></div><div dir=3D"auto"><a href=3D"https://github.com/s-h=
ironobu/pg_plan_inspector">https://github.com/s-hironobu/pg_plan_inspector<=
/a><br></div><div dir=3D"auto"><br></div><div dir=3D"auto">not totally ai, =
but it can use data from your database to build some metadata.</div><div di=
r=3D"auto"><br></div><div dir=3D"auto">there are also plan analyzers online=
 which people paste their plan to get a quick summary of problem areas, tha=
t data can be useful too for ai based plan optimisers.</div><div dir=3D"aut=
o"><br></div><div dir=3D"auto">but that said, postgresql has a lot of knobs=
 to tune, so ...</div><div class=3D"gmail_quote" dir=3D"auto"></div></div>

--000000000000d29a49061b7bbdc7--