number of wal file is not reduced.

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: number of wal file is not reduced.
Date: 2021-07-05 09:48:14
Message-ID: CA+ONtZ6nyNvtiR2mQv12SD9X-yn9a-=etBK29HfE2xyDT61Eag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-07-05 10:51:26 Re: number of wal file is not reduced.
Previous Message Avi Weinberg 2021-07-05 08:59:30 RE: Logical Replication - Single Destination Table With Multiple Source Tables - How to Handle Structure Changes