To get the values right, you have to consider the "unit" column in
pg_settings. On mine, it is 16M for both min and max wal size. So it
would be
1024 x 1024 x 16 x (pg_settings.min_wal_size or
pg_settings.max_wal_size)
The result of this formula should be close to what you specified in
Hello,
We're encountering some problems with WAL growth in production with
PostgreSQL 9.6.3 and 9.6.2. From what I know a WAL file can either be
recycled(and would be reused) or deleted.
We'd like to have better control over the amount of WAL that is kept around.
There were a few occasions where