The new "Notes left on my edits" page (
MBS-8676) performs badly and only became feasible by restricting it to edit notes from the last three months. The reason for this is that the "recipient" of the edit note, i.e. the editor who made the edit, is only available in the edit table, requiring a complete join with edit_note.
To improve the performance, we would need some kind of "two-table index" which isn't possible. Instead, we sh to add a materialized view storing the "recipient" for every edit note, i.e. (recipient_editor_id, edit_note_id), with an index on recipient_editor_id; a trigger operating on inserts into edit_note would be enough to keep it updated.