Prateek Arora: I timed 179 index recommendations on real data. 18% made the query slower.

T2Covered by 1 source · first reported by Planet PostgreSQL at 05 Oct, 18:30 UTC

My tool tells you things like “this index cuts the query’s cost by 91%”. Before releasing it, I wanted to know what that number is actually worth. The tool is PgLens, a Postgres index advisor I’m building. Like several other advisors, it checks each suggestion with HypoPG: create a hypothetical…

cloud

Sources

• T2Prateek Arora: I timed 179 index recommendations on real data. 18% made the query slower.Planet PostgreSQL05 Oct, 18:30