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 good to d…

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 t…

[이미지] 佳闻_刘: 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 si…

방금 Discourse를 설치했는데, 외부 데이터베이스가 느려서 페이지 로딩이 매우 느립니다

지원 자체 호스팅

pfaffman (Jay Pfaffman) 3월 19, 2025, 10:30오후 3

표준 설치를 했나요?

글		댓글	조회수
Are there any commands that will speed up the site? Support	19	2456	12월 2, 2020
Best configurations for speeding up standalone discourse Self-hosting server-resources	25	4438	2월 14, 2024
My self host isn't as "fast" as other sites Self-hosting server-resources	11	432	5월 14, 2024
My discourse speed is very slow Self-hosting	24	5269	3월 4, 2021
Extreme Slow page loading (more than 1 minute to load) Support	9	853	9월 19, 2020

방금 Discourse를 설치했는데, 외부 데이터베이스가 느려서 페이지 로딩이 매우 느립니다

Related topics