4 ms·

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. Moreover, at SIGMOD 2019 there

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. 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/02/autoindexing_azuredb.pdf 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.

BrentOzar 5y ago
> 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 https://dba.stackexchange.com/q/208947/426
- polskibus 5y ago
  Thank you very much for this insight about MS SQL! My point about building an indexing hint tool for auto-indexing in Postgresql still stands though - it could be great for cloud deployments.