Ever since a rebuild hanged we’ve been experiencing high loads periodically with no obvious cause (other than it started after that upgrade/hang). Well tonight I think I was able to manually trigger it - by going to the ACP > Reports > Top Traffic Sources then setting the dates from the beginning of the year to today. So it appears big/complex queries may be triggering it - anyone else experiencing the same or also able to trigger it?

You might need more ram or to give more ram to postgres.

Do you mean in the container under db_shared_buffers: "4096MB"? It says 25% of total memory (server has 64GB) so Ill try upping this to 10GB. That’s the only performance related setting I can recall… are there any others we should be aware of or routinely checking/tweaking? Edit: just looked and there’s also: ## can improve sorting performance, but adds memory usage per-connection #db_work_mem: "40MB" Any threads that discuss this anywhere? (Or do you or anyone else have any thoughts?)

Increased to 10GB and tried again - same issue tho. These problems started after that rebuild hang so I suspect it is something to do with some kind of change from a version around that time :confused:

בעיות טעינת שרת (לאחר בנייה נעצר)

תמיכה התקנה

pfaffman (Jay Pfaffman) 19 במאי,‏ 2024,‏ 7:06am 5

I’d bump that to at least 100MB

נושא		תגובות	צפיות
Rebuild hanging Self-hosting	5	535	3 במאי,‏ 2024
Post 3.5.1 update - CPU maxed out 100% Product Support	4	263	4 בפברואר,‏ 2025
Long loading times for user summary page with slow database Self-hosting unsupported-install	17	2195	29 באוקטובר,‏ 2019
Endlessly running Postgres processes & bad performance after Reinstall/restore Product Support postgres	9	426	17 בפברואר,‏ 2025
Unusually high CPU usage Self-hosting	31	1513	18 בפברואר,‏ 2026

בעיות טעינת שרת (לאחר בנייה נעצר)

נושאים קשורים