Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Ideas #45

Open
13 tasks
ankane opened this issue Mar 26, 2023 · 0 comments
Open
13 tasks

Ideas #45

ankane opened this issue Mar 26, 2023 · 0 comments

Comments

@ankane
Copy link
Owner

ankane commented Mar 26, 2023 •
edited

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)
Repository owner locked and limited conversation to collaborators Mar 26, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ankane