Brievox

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

An evaluation of PgLens, a PostgreSQL index advisor, finds that 18% of 179 index recommendations make queries slower on real data. PgLens uses HypoPG to test hypothetical indexes and retains suggestions when the planner’s estimated cost falls by at least 15%.

1 source Published Updated

Coverage 1 publisher

  1. Planet PostgreSQL

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

Articles stay on their publishers’ sites; each link opens the original.