remove n^2 part of person triggers, improve community aggregate trigger (#3739)

[lemmy.git] / migrations / 2023-07-14-215339_aggregates_nonzero_indexes / down.sql

-- This file should undo anything in `up.sql`
DROP INDEX idx_community_aggregates_nonzero_hotrank;
DROP INDEX idx_comment_aggregates_nonzero_hotrank;
DROP INDEX idx_post_aggregates_nonzero_hotrank;