Обсуждение: pg_wal directory
Hello
May i know which setting in postgres controls the size and number of wal files kept in pg_wal directory? We have 245 wal files and total size is 3.5GB
We do NOT have replication in place
we are using
Pg 12.7
few settings we have
max_wal_size 16G
wal_keep_segments 8
On Fri, Jul 16, 2021 at 2:43 AM Yambu <hyambu@gmail.com> wrote:
HelloMay i know which setting in postgres controls the size and number of wal files kept in pg_wal directory? We have 245 wal files and total size is 3.5GB
We do NOT have replication in place
So how are you doing WAL archiving for backups? Because most likely that is broken and thus PostgreSQL doesn't feel safe in removing the unarchived WAL.
we are usingPg 12.7max_wal_size 16G
That seems a bit excessive...and above your current usage so it is possible you simply need that many segments given the volume of WAL your server produces (you omitted mentioning the time frame for the WAL)
wal_keep_segments 8
You don't have replication in place so wal_keep_segments, a replication GUC, is immaterial here.
David J.