OP here (happy to see this on HN!) - if you're interested in our work in this area, I hosted a webinar earlier this week where we walked through a new constrain

OP here (happy to see this on HN!) - if you're interested in our work in this area, I hosted a webinar earlier this week where we walked through a new constraint programming based system (utilizing CP-SAT) for Postgres index selection that we're starting to roll out in pganalyze: https://www.youtube.com/watch?v=SlNQTtfjlnI https://www.youtube.com/watch?v=SlNQTtfjlnI Compared to the initial version, this updated version is both more configurable, as well as has better handling of competing objectives in index selection (write overhead vs query performance). If you want to give this a try, and have pganalyze set up / want to try it out, feel free to send me a message (email in profile).