Feature Overview

add max_wal_size and min_wal_size to installer template postgresql.conf.j2

Background, and strategic fit

Per customer request :

we use a postgresql database managed by the RedHat AAP installer, unfortunately the included template postgresql.conf.j2 doesn't contain variables for max_wal_size and min_wal_size therefore Postgresql will use it's own defaults - which is not enough

we get 10-20x messages a day

< 2022-09-19 05:07:30.807 UTC >LOG: checkpoints are occurring too frequently (28 seconds apart)

< 2022-09-19 05:07:30.807 UTC >HINT: Consider increasing the configuration parameter "max_wal_size".

(Optional) Use Cases

The customer is setting the values manually :

max_wal_size = 4GB

min_wal_size = 1GB

but it will be removed each time the installer is run.