Postgres Pro
Downloads
Home   >   mailing lists

Re: AI for query-planning? - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: AI for query-planning?
Date
Msg-id CAM+6J94tfLrHT93SnHM25WRfmd35bAP8xkAUMzZ_JWJERXvqRw@mail.gmail.com
Whole thread Raw
In response to AI for query-planning?  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general
Tree view


On Sat, Jun 22, 2024, 5:20 PM 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?




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 ...

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: AI for query-planning?
Next
From: Christoph Moench-Tegeder
Date:
Subject: Re: AI for query-planning?