@shitpisscum notifications seem to be some of the heaviest queries from what i've seen, so... i haven't looked into them yet

there's pete's patch to add indexes on them but i don't know if it'd make that big of a difference considering you're a single user instance