# Improving Instance Performance (Megatopics, Database Size and Extreme Load)

**URL:** <https://meta.discourse.org/t/improving-instance-performance-megatopics-database-size-and-extreme-load/144277>\
**Category:** Self-hosting\
**Created:** [14 maart 2020 om 01:02 UTC](https://meta.discourse.org/t/improving-instance-performance-megatopics-database-size-and-extreme-load/144277 "2020-03-14T01:02:32Z")\
**Posts on this page:** 1\
**Showing post:** 16

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [20 maart 2020 om 20:26 UTC](https://meta.discourse.org/t/improving-instance-performance-megatopics-database-size-and-extreme-load/144277/16 "2020-03-20T20:26:54Z")

</div>

Very helpful! Thanks for sharing!

We do have concrete near term plans to tame the `post_timings` table but megatopics will be a source of considerable ongoing pain for many, many years.

> ⚠ and remember that is _after_ @tgxworld did great work about a year ago to reduce the overall amount of work we do on megatopics, essentially switching to “low power mode” on these topics so they don’t hurt _as much_.

But don’t kid yourself: megatopics still hit _HARD_. 💥🥊

---

_[View the full topic](https://meta.discourse.org/t/improving-instance-performance-megatopics-database-size-and-extreme-load/144277)._
