Ideas

[ankane]

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)