Mirrors/lemmy
2
0
Fork 0
mirror of https://github.com/LemmyNet/lemmy synced 2025-02-17 14:39:00 +00:00
Code Issues Projects Releases Packages Wiki Activity
lemmy/migrations/2024-05-04-140749_separate_triggers
History
Exact
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
2024-05-09 08:18:55 -04:00
..
down.sql Optimize stuff in attempt to fix high amount of locks, and fix comment_aggregates.child_count (#4696) 2024-05-09 08:18:55 -04:00
up.sql Optimize stuff in attempt to fix high amount of locks, and fix comment_aggregates.child_count (#4696) 2024-05-09 08:18:55 -04:00