Maybe of interest - postgres planner documentation https://www.postgresql.org/docs/current/planner-optimizer.html https://www.postgresql.org/docs/current/plann

Maybe of interest - postgres planner documentation https://www.postgresql.org/docs/current/planner-optimizer.html https://www.postgresql.org/docs/current/planner-optimizer.ht... Genetic query optimiser: https://www.postgresql.org/docs/current/geqo.html https://www.postgresql.org/docs/current/geqo.html postgres has a number of hooks, which can be used to override the default behaviour. In particular, there are a bunch of hooks that can be used to install a custom query planner. https://github.com/AmatanHead/psql-hooks/blob/master/Readme.md#planner-hooks https://github.com/AmatanHead/psql-hooks/blob/master/Readme.... more generally, ignoring database query optimisation specifically, if you are interested in learning about discrete optimisation techniques, I recommend this course: https://www.coursera.org/learn/discrete-optimization https://www.coursera.org/learn/discrete-optimization