public inbox for [email protected]
help / color / mirror / Atom feedFrom: Vijaykumar Jain <[email protected]>
To: Andreas Joseph Krogh <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: AI for query-planning?
Date: Sat, 22 Jun 2024 20:25:29 +0530
Message-ID: <CAM+6J94tfLrHT93SnHM25WRfmd35bAP8xkAUMzZ_JWJERXvqRw@mail.gmail.com> (raw)
In-Reply-To: <VisenaEmail.38.c31ee0594849fa9d.1903fc67a71@origo-test01.app.internal.visena.net>
References: <VisenaEmail.38.c31ee0594849fa9d.1903fc67a71@origo-test01.app.internal.visena.net>
On Sat, Jun 22, 2024, 5:20 PM Andreas Joseph Krogh <[email protected]>
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 ...
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: AI for query-planning?
In-Reply-To: <CAM+6J94tfLrHT93SnHM25WRfmd35bAP8xkAUMzZ_JWJERXvqRw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox