]> Untitled Git - lemmy.git/blob - migrations/2023-06-24-185942_aggegates_published_indexes/up.sql
add enable_federated_downvotes site option
[lemmy.git] / migrations / 2023-06-24-185942_aggegates_published_indexes / up.sql
1 -- Add indexes on published column (needed for hot_rank updates)
2 CREATE INDEX idx_community_aggregates_published ON community_aggregates (published DESC);
3
4 CREATE INDEX idx_comment_aggregates_published ON comment_aggregates (published DESC);
5