Hi,
I have postgres 9.6 running server on centos 7, the number of wal file
in pg_xlog directory is above 4000 so to save some disk space, I
thought of reducing to 100.
but there is no reduction in numbers.
Please not that there is no replication is configured, the server is
independent.
What I am missing here.
• max_wal_size = '3GB'
• checkpoint_timeout = '15min'
• checkpoint_completion_target=0.8
• log_checkpoints=on
• wal_keep_segments=100 (initially it was set to 4000)
Please suggest when the number of wal files will be reduced to approx 100.
regards,
Atul