News for hackers. Stuff that matters.

A comment on Show HN: PostgreSQL Index Advisor. Parent comment

Re:Show HN: PostgreSQL Index Advisor by Ciantic on Sunday April 14, 2024 @07:10AM (#40030293)
"Automatic tuning, introduced in SQL Server 2017 (14.x), notifies you whenever a potential performance issue is detected and lets you apply corrective actions, or lets the Database Engine automatically fix performance problems." [1]

I have used this in Azure SQL too, but according to that it should be in SQL Server.

https://learn.microsoft.com/en-us/sql/relational-databases/a...

[ Parent | on HN ]
Re:Show HN: PostgreSQL Index Advisor by couchand on Sunday April 14, 2024 @09:02AM (#40030798)
Good link!

> Automatic index management identifies indexes that should be added in your database, and indexes that should be removed. Applies to: Azure SQL Database

[ Parent | on HN ]
Re:Show HN: PostgreSQL Index Advisor by BrentOzar on Sunday April 14, 2024 @09:56AM (#40031065)
Read that link carefully: only automatic plan regression is available in SQL Server, not the automatic index tuning portion. The index tuning portion only applies to Azure SQL DB.
[ Parent | on HN ]