Search Postgresql Archives

Re: AI for query-planning?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Sat, Jun 22, 2024, 5:20 PM Andreas Joseph Krogh <andreas@xxxxxxxxxx> 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 ...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux