lemmy/migrations/2023-07-19-163511_comment_sort_hot_rank_then_score/down.sql

DROP INDEX idx_comment_aggregates_hot, idx_comment_aggregates_score;

CREATE INDEX idx_comment_aggregates_hot ON comment_aggregates (hot_rank DESC, published DESC);

CREATE INDEX idx_comment_aggregates_score ON comment_aggregates (score DESC, published DESC);
Adding SQL format checking via `pg_format` / pgFormatter (#3740) * SQL format checking, 1. * SQL format checking, 2. * SQL format checking, 3. * SQL format checking, 4. * SQL format checking, 5. * Running pg_format * Getting rid of comment. * Upping pg_format version. * Using git ls-files for sql format check. * Fixing sql lints. * Addressing PR comments. 2023-08-02 16:44:51 +00:00			`DROP INDEX idx_comment_aggregates_hot, idx_comment_aggregates_score;`

			`CREATE INDEX idx_comment_aggregates_hot ON comment_aggregates (hot_rank DESC, published DESC);`

			`CREATE INDEX idx_comment_aggregates_score ON comment_aggregates (score DESC, published DESC);`
Make sure comments are sorted by hot_rank, then score. (#3667) 2023-07-21 09:44:47 +00:00