PostgreSQL runaway IO

[Falco]

@JanJoost

Would it be better to break it up in pieces, close this one and open a new one?

Yes. I set auto close topics post count to 1024 or 512 when I had an HDD instance.

Also, I completely forgot, but looks like I took an stab at this query 2 years ago:

Post.calculate_avg_time() taking up a long time

I believe the daily version of the query can be optimized by moving the filter up in the subquery. Before: kmV3 : Discourse Post.calculate_avg_time daily | explain.depesz.com After: i3JU : Discourse Post.calculate_avg_time daily Optimized | explain.depesz.com This would not apply to the weekly one, but as you stated the daily one is the bugger. Can you try that and confirm the differences @michaeld ?