Every time a post is hidden or unhidden, the post_hidden trigger is called that finds a new latest_post_id and latest_post_at candidate for the post's topic.
This is bad for bulk post.is_hidden = true updates like the nukeUser fn.
However, since we ~always nuke new users with barely any posts, we don't necessarily run into a perf issue.
Every time a post is hidden or unhidden, the
post_hiddentrigger is called that finds a newlatest_post_idandlatest_post_atcandidate for the post's topic.This is bad for bulk
post.is_hidden = trueupdates like thenukeUserfn.However, since we ~always nuke new users with barely any posts, we don't necessarily run into a perf issue.