From: | Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: max_slot_wal_keep_size and wal_keep_segments |
Date: | 2020-07-13 05:11:05 |
Message-ID: | e57147a0-4cf0-1222-9a93-2c11eea0852e@oss.nttdata.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2020/07/09 1:20, Alvaro Herrera wrote:
> On 2020-Jul-09, Fujii Masao wrote:
>
>> I attached the patch that renames wal_keep_segments to wal_keep_size.
>
> Looks good in a quick once-over. Just two small wording comments:
Thanks for review comments!
>
>> <para>
>> Independently of <varname>max_wal_size</varname>,
>> - <xref linkend="guc-wal-keep-segments"/> + 1 most recent WAL files are
>> + most recent <xref linkend="guc-wal-keep-size"/> megabytes
>> + WAL files plus one WAL file are
>> kept at all times. Also, if WAL archiving is used, old segments can not be
>> removed or recycled until they are archived. If WAL archiving cannot keep up
>> with the pace that WAL is generated, or if <varname>archive_command</varname>
>
> This reads a little strange to me. Maybe "the N most recent megabytes
> plus ..."
Yes, fixed.
>
>> /* determine how many segments slots can be kept by slots ... */
>> - keepSegs = XLogMBVarToSegs(max_slot_wal_keep_size_mb, wal_segment_size);
>> - /* ... and override by wal_keep_segments as needed */
>> - keepSegs = Max(keepSegs, wal_keep_segments);
>> + slotKeepSegs = XLogMBVarToSegs(max_slot_wal_keep_size_mb, wal_segment_size);
>> + /* ... and override by wal_keep_size as needed */
>> + keepSegs = XLogMBVarToSegs(wal_keep_size_mb, wal_segment_size);
>
> Since you change the way these two variables are used, I would not say
> "override" in the above comment, nor keep the ellipses; perhaps just
> change them to "determine how many segments can be kept by slots" and
> "ditto for wal_keep_size".
Yes, fixed.
Attached is the updated version of the patch.
Regards,
--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION
Attachment | Content-Type | Size |
---|---|---|
wal_keep_size_v2.patch | text/plain | 14.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2020-07-13 05:14:30 | Re: max_slot_wal_keep_size and wal_keep_segments |
Previous Message | Dilip Kumar | 2020-07-13 05:09:43 | Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions |