RE: why wal_max_size does not work?

From: Fan Liu <fan(dot)liu(at)ericsson(dot)com>
To: Sergei Kornilov <sk(at)zsrv(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: why wal_max_size does not work?
Date: 2020-03-27 06:10:05
Message-ID: HE1PR0701MB2569825FAAE5AD96267CE3709ECC0@HE1PR0701MB2569.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks for the reply.

Yes, I understand wal_max_size is a soft limit. But we don’t' have heavy traffic. It's like 4 UPDATE per 2 seconds.
Our data folder is a 4GB network storage, the WAL file folder is around 3.7G.

So, light traffic with 3.7G WAL, no recycling.
We have archive_mode = off
And max_replication_slots = '10'

You can find my postgresql.conf in my first mail.

So, I wan to know under what kind of scenario that there will not be recycling old WAL files.
Is there any way I can check the recycling? For example, logs?

Attach logs

BRs,
Fan Liu

>>-----Original Message-----
>>From: Sergei Kornilov <sk(at)zsrv(dot)org>
>>Sent: 2020年3月24日 20:33
>>To: Fan Liu <fan(dot)liu(at)ericsson(dot)com>; PostgreSQL mailing lists
>><pgsql-bugs(at)lists(dot)postgresql(dot)org>
>>Subject: Re: why wal_max_size does not work?
>>
>>Hello
>>
>>max_wal_size is not the upper limit for pg_wal. Postgresql does not have upper
>>limit for pg_wal at all. This is documented:
>>
>>https://www.postgresql.org/docs/10/runtime-config-wal.html
>>> Maximum size to let the WAL grow to between automatic WAL checkpoints. This
>>is a soft limit; WAL size can exceed max_wal_size under special circumstances,
>>like under heavy load, a failing archive_command, or a high wal_keep_segments
>>setting.
>>
>>so check yours replication slots, archive_command (if archive_mode is enabled),
>>wal_keep_segments
>>
>>regards, Sergei

Attachment Content-Type Size
pg_wal.log application/octet-stream 20.4 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2020-03-27 06:36:25 Re: why wal_max_size does not work?
Previous Message PG Bug reporting form 2020-03-27 03:21:40 BUG #16321: Memory leaks in PostmasterMain