Ideas
ankane opened this issue · 0 comments
ankane commented
Please create a new issue to discuss any ideas or share your own.
Ideas
- determine write-heavy tables automatically
- notifications when indexes found (email & Slack)
- only create indexes at certain times of day (low traffic times) - one approach is to run Dexter daily instead of stream
- option to write created/suggested indexes to table (in
dexter
schema) - optimize across all queries (get N best indexes for a query)
- non-BTREE indexes (add support to hypopg)
- use multiple samples for each fingerprint
- add support for directions to multicolumn indexes
- calculate total time saved, and order indexes by this
- prefer lots of small partial indexes over full indexes
Full index management
- drop duplicate/covered indexes
- drop unused indexes -
drop_unused
branch (have to be careful with replicas) - drop indexes that have little benefit (have to be careful with replicas)