# Performance optimization, what about max\_wal\_size?

**URL:** <https://meta.discourse.org/t/performance-optimization-what-about-max-wal-size/287422>\
**Category:** Self-hosting\
**Tags:** performance\
**Created:** [December 4, 2023, 12:39pm UTC](https://meta.discourse.org/t/performance-optimization-what-about-max-wal-size/287422 "2023-12-04T12:39:11Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Paracelsus](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/paracelsus/32/164912_2.png) [@Paracelsus](https://meta.discourse.org/u/Paracelsus)\
**Post date:** [December 4, 2023, 12:39pm UTC](https://meta.discourse.org/t/performance-optimization-what-about-max-wal-size/287422/1 "2023-12-04T12:39:11Z")

</div>

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)](https://www.enterprisedb.com/blog/tuning-maxwalsize-postgresql)  
[Tuning Your Postgres Database for High Write Loads (crunchydata.com)](https://www.crunchydata.com/blog/tuning-your-postgres-database-for-high-write-loads)  
[PostgreSQL Performance Tuning and Optimization Guide - Sematext](https://sematext.com/blog/postgresql-performance-tuning/)

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, 😃 but sometimes we are forced to optimize and try to get the best possible performance for our (finite) resources.

---

_[View the full topic](https://meta.discourse.org/t/performance-optimization-what-about-max-wal-size/287422)._