index advisor
Data
database index advisor
SHOW HN2024
How HN took it
5 positive, 18 neutral or asking, 0 mixed, 7 critical, out of 30 comments about the project. Thread score +0.02.
Idea: 1 for, 6 againstDesign: 2 for, 0 againstPerformance: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful tool; Supabase team delivers
From 1 comment
The supabase team always delivers. Excited to give this a try!
pkiv on HN
Written in plain PL/pgSQL, easy to adapt
From 1 comment
The convenient thing about this is that it's written in vanilla Pl/PgSQL. It can be tempting to copy the `index_advisor(text)`function in a session and start hard-coding stuff…
fforflo on HN
Objections
Automatic indexing ignores write costs and tradeoffs
From 2 comments
I'm sure the database could, but it doesn't mean the database should. Indexes come at the cost of extra disk space, slower inserts, and slower updates. In some cases, some slower…
elric on HNThis doesn't seem to consider or give insight on any tradeoffs involved. Also, the underlying extension, HypoPG, doesn't seem to collect any statistics on data to influence query…
ComodoHacker on HN
Does not collect statistics to influence planner
From 1 comment
This doesn't seem to consider or give insight on any tradeoffs involved. Also, the underlying extension, HypoPG, doesn't seem to collect any statistics on data to influence query…
ComodoHacker on HN
Requests
Support for RDS installation
From 1 comment
How does one install this on a aws rds instance?
Bishonen88 on HN
Index deletion and merge suggestions
From 1 comment
Having creation advice, the extension obviously must provide candidates to delete and, less obvious, candidates to merge some indexes.
danolivo on HN
Questions
Is the advisor cost-based or rule-based, and how reliable is it?
From 1 comment
I need such a tool. The only concern is whether this advisor can really give reliable indexing advice? Is it based on cost or rules? Maybe I would dare to use it after knowing…
SiliconGuru on HN
Does it handle inherited parent and child tables?
From 1 comment
Is this aware of parent and child inherited tables?
gregw2 on HN
Alternatives named
pganalyze index advisor
From 2 comments
My team has been using Pganalyze (which has its own index advisor), and honestly, it's one of my favorite technical tools ever. I don't know how you could run a large-scale…
Ozzie_osman on HNIf you have some PostgreSQL performance issues, I'd recommend checking out PGAnalyze - they've offered a much more advanced index advisor for some time now. My company is a paid…
CAP_NET_ADMIN on HN
dexter
From 2 comments
Andrew Kane built dexter, which is an automatic indexer for Postgres. https://github.com/ankane/dexter https://ankane.org/introducing-dexter
b3lm0nt on HNdexter uses a similar premise with hypog. https://github.com/ankane/dexter
jensenbox on HN
pg_hint_plan
From 1 comment
Guessing you've seen this already and it's not doing what you want? https://github.com/ossc-db/pg_hint_plan
justinclift on HN
SQL Server / Azure SQL automatic tuning
From 2 comments
That exists in Microsoft SQL Server. It can create new indexes, drop unused indexes, change query plans when it detect degradation and so on.
tuwtuwtuwtuw on HN"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…
Ciantic on HN