Ideas

[ankane]

Please create a new issue to discuss any ideas or share your own.

Ideas

• support indexing partitioned tables without the --non-concurrently option
• 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)