# Load test with Discourse

**URL:** <https://meta.discourse.org/t/load-test-with-discourse/77291>\
**Category:** Development\
**Created:** [January 5, 2018, 7:31am UTC](https://meta.discourse.org/t/load-test-with-discourse/77291 "2018-01-05T07:31:57Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![SimonWu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simonwu/32/85036_2.png) [@SimonWu](https://meta.discourse.org/u/SimonWu)\
**Post date:** [January 5, 2018, 2:39pm UTC](https://meta.discourse.org/t/load-test-with-discourse/77291/6 "2018-01-05T14:39:23Z")

</div>

Yes, the slow query is the a join operation of table `topic` and `topic_user_ids`. When user has created a lot of topics before, the operation of show latest page will be slow. I will try to tune it by using better PostgresSQL and `work_mem` and `shared_buffers`. Thanks @mpalmer nd @Falco

---

_[View the full topic](https://meta.discourse.org/t/load-test-with-discourse/77291)._