| 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: | Whole Thread | Raw Message | 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
| 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 |