Homepage take up 2-4 sec to respond Started GET "/" for 219.144.218.209 at 2025-03-17 18:22:55 +0000 Processing by ListController#latest as HTML Rendered layout layouts/application.html.erb (Duration: 1932.6ms | GC: 10.6ms) Completed 200 OK in 2521ms (Views: 1933.4ms | ActiveRecord: 0.0ms (0 que…

Did you do a standard install ?

Yes, i did. And i found issue yesterday. I used a remote database, The layout component of discourse fetch 60+sqls, every sql need ±30ms to transfer，so the first render cause 2-4 sec. The issue go away when I changed to local database.

[изображение] TrevorWoods: Check if your server meets Discourse’s recommended specs Yes, it does: [изображение] 佳闻_刘: 2 CPU cores and 8GB of RAM

I’m having a similar problem. I think the docker might be doing some kind of magic indexing on internal databases only, which isn’t great as that severely limits how we can scale.

[изображение] Eviepayne: I think the docker might be doing some kind of magic indexing on internal databases only Hmmm … that doesn’t sound right to me. The same migrations should be being applied regardless of where the database is … and that includes the addition of indexes. It would be g…

I have this plan I did a while ago for a long running query: Plan created on March 28th 2025, 4:09 pm | explain.dalibo.com Visualizing and understanding your PostgreSQL execution plans made easy. This plan WAS a database that was locally hosted, disk IO was…

[изображение] 佳闻_刘: every sql need ±30ms to transfer This is comparatively a huge amount of time. There’s something very wrong with your SQL setup. How remote is the database? 99th percentile of total SQL time for logged-in requests on meta (hosted in AWS) is ~54ms and on our metal hosting …

Только что установил Discourse, но страницы загружаются очень медленно из-за медленной внешней базы данных

Поддержка Самостоятельное хостинг

pfaffman (Jay Pfaffman) 19.Март.2025 22:30:01 3

Вы выполнили стандартную установку?

Тема		Ответов	Просм.
Are there any commands that will speed up the site? Support	19	2282	02.12.2020
Best configurations for speeding up standalone discourse Self-hosting server-resources	26	4265	14.02.2024
My self host isn't as "fast" as other sites Self-hosting server-resources	11	344	14.05.2024
My discourse speed is very slow Self-hosting	24	4915	04.03.2021
Extreme Slow page loading (more than 1 minute to load) Support	9	800	19.09.2020

Только что установил Discourse, но страницы загружаются очень медленно из-за медленной внешней базы данных

Связанные темы