not sure if this is where pganalyze is going, if not - it's certainly worth a read. Whatever you guys end up building, it may be a good idea to architect it in a way that makes auto-indexing like in Azure possible.
> This is one of the feature that MS SQL Server has and it works very well. It can suggest indexes with a pretty good correctness.
Not really: it's just a comma-delimited list of columns to consider indexing, sorted by the column order in the table. It just looks scientific to folks because they don't realize that. https://dba.stackexchange.com/q/208947/426
Moreover, at SIGMOD 2019 there was a paper where they do that automatically in Azure, forking the dbs and loads!. https://www.microsoft.com/en-us/research/uploads/prod/2019/0...
not sure if this is where pganalyze is going, if not - it's certainly worth a read. Whatever you guys end up building, it may be a good idea to architect it in a way that makes auto-indexing like in Azure possible.