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_size can be very important for performance (second only to shared_buffers according to some, see below): Tuning max_wal_size in PostgreSQL | EDB (enterprisedb.com) Tuning Your Postgres Database for High Write Loads (crunchydata.com) PostgreSQL Performance Tuning and Optimization Guide - Sematext Any opinions on this? Should max_wal_size parameter be changed even if this only happened during update? For context, we have a big forum with more than 7 million posts, that consumes a lot of resources, a couple of times a week with 400-600 simultaneous users refreshing and posting and doing everything at the same time. No problems with that, :smiley: but sometimes we are forced to optimize and try to get the best possible performance for our (finite) resources.

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).

Performance optimization, what about max_wal_size?

Product Support Self-hosting

Falco (Falco) December 4, 2023, 1:04pm 2

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

Topic		Replies	Views
Consider increasing the configuration parameter "max_wal_size" Product Support	2	6028	July 12, 2016
Server load issues (after rebuild hanged) Self-hosting	4	313	May 19, 2024
Database size/maintenance Self-hosting	1	732	September 7, 2022
Long runtime moving posts / timeout errors Product Support	3	174	February 9, 2025
Check on our table sizes Product Support	0	82	May 31, 2025

Performance optimization, what about max_wal_size?

Related topics