Hi, Latest update from beta-3 to beta-4 was more “cumbersome” than usual for us and something like the following kept coming up because of the logs: Consider increasing the configuration parameter "max_wal_size". Since I’m no expert on this matter, googling it showed that this parameter max_wal_s…

What’s the value of running SELECT checkpoints_timed, checkpoints_req FROM pg_stat_bgwriter; against the DB ?

Let’ see if I got it right: SELECT checkpoints_timed, checkpoints_req FROM pg_stat_bgwriter; checkpoints_timed | checkpoints_req -------------------+----------------- 4936 | 225 (1 row)

Looks like it was caused mostly by migrations during the update, and day to day the forum is fine. We did ship some heavy weight migrations this month, you don’t happen to have your rebuild log around do you?

Nope, I can try to find it somewhere later on, but I trust your judgement :+1: (the forum works ok apart from some load issues during those peak hours I mentioned).

性能优化，max_wal_size 怎么样？

支持安装

Falco (Falco) 2023 年12 月 4 日 14:02 4

看起来主要是由更新期间的迁移引起的，而且论坛日常运行正常。

本月我们进行了一些重量级的迁移，您手头有重建日志吗？

2 个赞

话题		回复	浏览量
Consider increasing the configuration parameter "max_wal_size" Support	3	5974	2024 年6 月 8 日
Server load issues (after rebuild hanged) Self-hosting	4	219	2024 年5 月 19 日
Database size/maintenance Self-hosting	1	647	2022 年9 月 7 日
Long runtime moving posts / timeout errors Support	3	64	2025 年2 月 9 日
Check on our table sizes Support	0	39	2025 年5 月 31 日

性能优化，max_wal_size 怎么样？

相关话题