I’m trying to optimize a multi-docker Discourse instance for a forum with over 3M posts. Once loaded, Disourse is quite fast. Problem is that the first page load (or full F5 refresh) takes 4-5 seconds. There is one SQL query that is responsible for 3,9 of these 4 seconds. This is consistent and …

It’s after import from IPB. I’ll try that.

It helped, can you explain why this could be an issue?

You can read more about it here [Beibei] How do I know if the statistics of a Postgres table are up to date? postgresql, statistics, analyzer, vacuum asked by Beibei on 08:17PM - 01 Aug 11 UTC

Slow (over 3 sec) SQL query

Product Support Self-hosting

sam (Sam Saffron) 2017 年 1 月 20 日午後 12:39 2

If this is an import, try backing up and restoring from backup, stats may be in a bad state

トピック		返信	表示
Slow SQL query causes homepage to load in 2-4 sec Product Support	15	1836	2018 年 2 月 7 日
App/models/topic_tracking_state - `report` - long response times? Development slow-sql	6	1946	2016 年 2 月 26 日
PostgreSQL runaway IO Self-hosting	35	3711	2021 年 3 月 3 日
Long loading times for user summary page with slow database Self-hosting unsupported-install	17	2147	2019 年 10 月 29 日
Posting is taking multiple seconds Product Support	21	1406	2020 年 5 月 15 日

Slow (over 3 sec) SQL query

関連トピック