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 |
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 |