You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
lemmy/crates
dullbananas c4fc3a8ede
Optimize stuff in attempt to fix high amount of locks, and fix comment_aggregates.child_count (#4696)
* separate triggers

* auto_explain.log_triggers=on

* Revert "auto_explain.log_triggers=on"

This reverts commit 078b2dbb9b.

* Revert "separate triggers"

This reverts commit 95600da4af.

* bring back migration

* re-order statements

* add comment about statement ordering

* no redundant updates

* optimize post_aggregates update in comment trigger

* set comment path in trigger

* update comment_aggregates.child_count using trigger

* move `LEFT JOIN post` to inner query

* clean up newest_comment_time_necro

* add down.sql
20 hours ago
..
api Fix community add mod check (fixes #4624) (#4667) 2 weeks ago
api_common On registration set show_nsfw based on site.content_warning (#4616) 2 days ago
api_crud On registration set show_nsfw based on site.content_warning (#4616) 2 days ago
apub Instance.preferred_username should be optional (fixes #4701) (#4713) 2 days ago
db_perf Dont publish lemmy_db_perf to fix crates.io publish. Fixes #4678 (#4680) 1 week ago
db_schema Optimize stuff in attempt to fix high amount of locks, and fix comment_aggregates.child_count (#4696) 20 hours ago
db_views Dont show own comments for liked and disliked_only. Fixes #4675 (#4679) 1 week ago
db_views_actor Make all single-fetch database calls return an Option. (#4617) 3 weeks ago
db_views_moderator Fixing extra modlog entries when post_id or comment_id is given. (#4664) 2 weeks ago
federate Make all single-fetch database calls return an Option. (#4617) 3 weeks ago
routes chore: fix some comments (#4637) 3 weeks ago
utils Add timeout for processing incoming activities (#4708) 2 days ago