Denormalize community_id into post_aggregates for a 1000x speed-up when loading posts...

[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;