We have 5M posts and searching is pretty snappy. Hosting on a 6 shared vcores of a 2.8Ghz Xeon E5-2680 with 16GB RAM and SSD storage. That said I don’t have metrics on how many simultaneous posts our users initiate, there might be locking issues. Posting, on the other hand, is often quite slow. It can take 6-7 seconds for a post to go through. Discourse is non-blocking when it chugs away so that doesn’t kill the user experience, though.

[image] Wingtip: It can take 6-7 seconds for a post to go through. This is.. not normal.

I think this is most likely the case on any topic with 100s or 1000s of posts. On short topics this should not be the case. I recall @Wingtip’s forum has tons of very long topics.

Are the 6-7 second post times specific to the mega topics? If you reply to a topic with 100 replies, does it also take 6-7 seconds?

I was unable to reproduce just now-- slow posting is intermittent. It doesn’t seem to correlate with post count in the thread. Maybe it’s a locking issue with someone else posting simultaneously or something. 7 posts = very fast, roughly the same as here on meta 500 posts = maybe slightly slower, not too bad. Maybe 1.5 second? 16k posts = seems about the same as with 500

That makes sense, to prioritize the experience of many people viewing a thread over one or two trying to post.

How brave are you feeling? Do you mind enabling mini_profiler for a bit? It will give you timings on the side, then we can isolate which query is playing up for you! My post here took 576ms [image] The worst query is: [image] And @riking is working on a PR that will fix this :confetti_ball:

How much does enabling it impact overall performance? And can it be enabled without a site rebuild? I haven’t been able to get a rebuild to succeed since the postgres 12 change, even by setting it to stick with pg10.

You need to set your email address as the developer email in the app.yml file. You can apply it without a rebuild by destroying and restarting the container. It you have made changes to the container, by upgrading with discourse docker they will be lost. You can also edit config/discourse conf inside the container and then sv restart unicorn

Posting is taking multiple seconds

Product Support

pfaffman (Jay Pfaffman) May 13, 2020, 5:08pm 7

And I believe that performance is also affected if a bunch of people are accessing a mega topic, which slows down the whole PG server with queued requests.

Topic		Replies	Views
Improving Instance Performance (Megatopics, Database Size and Extreme Load) Self-hosting	60	6831	October 13, 2020
Users reporting lots of 502 errors when attempting to post due to "max consecutive replies" check Bug	36	3420	January 18, 2019
PostgreSQL runaway IO Self-hosting	35	3872	March 3, 2021
Major slowdown for staff in large topics Product Support	12	2449	June 3, 2019
Slow (over 3 sec) SQL query Self-hosting hosting	4	1480	January 20, 2017

Posting is taking multiple seconds

Related topics