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…

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.

[image] TrevorWoods: Check if your server meets Discourse’s recommended specs Yes, it does: [image] 佳闻_刘: 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.

[image] 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 good to…

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…

[image] 佳闻_刘: 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 for a …

I just installed Discourse, but the pages load very slowly due to slow external database

Support Self-hosting

pfaffman (Jay Pfaffman) March 19, 2025, 10:30pm 3

Did you do a standard install?

Topic		Replies	Views
Are there any commands that will speed up the site? Support	19	2268	December 2, 2020
Best configurations for speeding up standalone discourse Self-hosting server-resources	26	4224	February 14, 2024
My self host isn't as "fast" as other sites Self-hosting server-resources	11	328	May 14, 2024
My discourse speed is very slow Self-hosting	24	4893	March 4, 2021
Extreme Slow page loading (more than 1 minute to load) Support	9	793	September 19, 2020

I just installed Discourse, but the pages load very slowly due to slow external database

Related topics