Skip to content

Remove an unused index on notes table

euko requested to merge 435151-drop-unused-index into master

What does this MR do and why?

Removes the index note_mentions_temp_index. The index was created to back a feature that never rolled out https://gitlab.slack.com/archives/C72HPNV97/p1702462697440749:

gitlabhq_production=> SELECT * FROM pg_stat_all_indexes WHERE indexrelname in ('note_mentions_temp_index');
 relid | indexrelid | schemaname | relname |       indexrelname       | idx_scan | idx_tup_read | idx_tup_fetch 
-------+------------+------------+---------+--------------------------+----------+--------------+---------------
 33614 | 3410300955 | public     | notes   | note_mentions_temp_index |        0 |            0 |             0
(1 row)

Related to #435151 (closed)

Edited by euko

Merge request reports