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

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

我刚安装了 Discourse，但由于外部数据库速度慢，页面加载非常缓慢

支持安装

pfaffman (Jay Pfaffman) 2025年三月19日 22:30 3

您是否执行了标准安装？

話題		回覆	觀看
Are there any commands that will speed up the site? Support	19	2534	2020年十二月2日
Best configurations for speeding up standalone discourse Self-hosting server-resources	25	4537	2024年二月14日
My self host isn't as "fast" as other sites Self-hosting server-resources	11	461	2024年五月14日
My discourse speed is very slow Self-hosting	24	5307	2021年三月4日
Extreme Slow page loading (more than 1 minute to load) Support	9	875	2020年九月19日

我刚安装了 Discourse，但由于外部数据库速度慢，页面加载非常缓慢

相關主題