[quizotic]

+1 for the idea of tuning query optimization based on ML. I don't know of any DBMSs that take this advice, and that's remarkable in this day and age.

[rev112]

This looks quite relevant: https://aws.amazon.com/blogs/ai/tuning-your-dbms-automatical... ("Tuning Your DBMS Automatically with Machine Learning")

The authors propose a way to do some automatic tuning for MySQL and Postgres.

Link to the paper itself: http://db.cs.cmu.edu/papers/2017/tuning-sigmod2017.pdf

[power]

Postgres has a query optimizer that uses Genetic Algorithms: https://www.postgresql.org/docs/current/static/geqo.html

Clarification: this is for planning how to execute a query, not for tuning the db settings

[agnivade]

Wow, did not know that. TIL!

[jve]

SQL Server 2017 has introduced 2 Automatic database tuning features: Automatic plan correction and Automatic index management (Latter for Azure SQL Only)

https://docs.microsoft.com/en-us/sql/relational-databases/au...

[vthriller]

Oracle already promised to bring something similar back in september: https://www.oracle.com/database/autonomous-database/index.ht...