Planet PostgreSQL – Dave Page: Tuning max_wal_size in PostgreSQL

Tuning of the max_wal_size configuration parameter in PostgreSQL can have a profound effect on performance, but it’s often overlooked or not given the priority it deserves in favour of other parameters, such as those that are easier to understand. In this blog we’ll discuss what the parameter does, how to tune it, and how to monitor the system to ensure the tuning is effective. [Continue reading…]

External feed Read More at the Source: https://postgr.es/p/5hP