number of wal file is not reduced. - Mailing list pgsql-general

From Atul Kumar
Subject number of wal file is not reduced.
Date
Msg-id CA+ONtZ6nyNvtiR2mQv12SD9X-yn9a-=etBK29HfE2xyDT61Eag@mail.gmail.com
Whole thread Raw
Responses Re: number of wal file is not reduced.  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Avi Weinberg
Date:
Subject: RE: Logical Replication - Single Destination Table With Multiple Source Tables - How to Handle Structure Changes
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: number of wal file is not reduced.