Async drop `index_events_on_author_id_and_created_at_merge_requests`
requested to merge 415090-drop-index-index_events_on_author_id_and_created_at_merge_requests-from-events-table into master
What does this MR do and why?
This MR asynchronously drops the index index_events_on_author_id_and_created_at_merge_requests from the events table. This index was created in Track merge_requests_users usage data (!32562 - merged).
index_events_on_author_id_and_created_at_merge_requests is not completely un-used, but not used much - see pg_stat_user_indexes_idx_scan, and pg_stat_user_indexes_idx_tup_read
Dropping this index from the events table will clear up some much needed gigabytes in the table.
MR acceptance checklist
-
I have evaluated the MR acceptance checklist for this MR.
Related to #415090 (closed)
This description was generated for revision 822b6c39 using AI
Edited by Gary Holtz