[commandlinefan]

> to mutate the status of individual posts and comment

AKA why you should normalize your data models.

[ElevenLathe]

Meh it's a tradeoff usually. De-normalize for better read performance at the expense of some complexity and worse update performance/semantics.

[eropple]

This is true, but FWIW (it probably wouldn't save you here, too much is changing too fast) something like a SQL materialized view can very often give you both the chocolate and the peanut butter.