I have a rare performance fix for Pleroma that will fix some issues resulting from having a very large notifications table: https://gitlab.com/soapbox-pub/rebased/-/merge_requests/301

tl;dr an index already existed but the code wasn't using it