Re: Stale description for pg_basebackup - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Stale description for pg_basebackup
Date
Msg-id deb1d98a-ce36-5adb-caa8-a0b7128deeb7@oss.nttdata.com
Whole thread Raw
In response to Re: Stale description for pg_basebackup  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: Stale description for pg_basebackup  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List pgsql-hackers

On 2021/04/22 11:19, Kyotaro Horiguchi wrote:
> At Thu, 22 Apr 2021 10:56:10 +0900, Fujii Masao <masao.fujii@oss.nttdata.com> wrote in
>>
>>
>> On 2021/04/22 9:25, Kyotaro Horiguchi wrote:
>>>> What about the following description?
>>>>
>>>> -------------------
>>>> When you are using -X none, if write activity on the primary is low,
>>>> pg_basebackup may need to wait a long time for all WAL files required
>>>> for
>>>> the backup to be archived. It may be useful to run pg_switch_wal
>>>> on the primary in order to trigger an immediate WAL file switch and
>>>> archiving.
>>>> -------------------
>>> Looks far better.
>>
>> Patch attached. I appended the following description to assist
>> users to understand why pg_basebackup may need wait a long time
>> when write activity is low on the primary.
>>
>> ------------------
>> pg_basebackup cannot force the standby to switch to
>> a new WAL file at the end of backup.
>> ------------------
> 
> I'm not sure which is the convention here, but I saw that some
> function names in the doc are followed by parentheses (ie
> pg_switch_wal()).

Either works for me. I didn't add "()" because I just used the same description
as that in func.sgml.

         it may be useful to run <function>pg_switch_wal</function> on the
         primary in order to trigger an immediate segment switch.)


> (prepended?) It seems a bit redundant but also a bit clearer. How
> about the following simplification?
> 
> - It may be useful to run pg_switch_wal on the primary in order to
> - trigger an immediate WAL file switch and archiving.
> + It may be useful to run pg_switch_wal() on the primary in that case.

IMO "in order to..." part is helpful for us to understand why pg_switch_wal
is useful in this case. So I'd like to leave it.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: ML-based indexing ("The Case for Learned Index Structures", a paper from Google)
Next
From: Dilip Kumar
Date:
Subject: Re: Replication slot stats misgivings