Re: [HACKERS] make async slave to wait for lsn to be replayed

From: Andy Fan <zhihuifan1213(at)163(dot)com>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Kartyshov Ivan <i(dot)kartyshov(at)postgrespro(dot)ru>, Euler Taveira <euler(at)eulerto(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [HACKERS] make async slave to wait for lsn to be replayed
Date: 2024-04-02 08:14:49
Message-ID: 87h6gk9nvc.fsf@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hi Alexander!

>> + </indexterm>
>> + <function>pg_wal_replay_wait</function> (
>> + <parameter>target_lsn</parameter> <type>pg_lsn</type>,
>> + <parameter>timeout</parameter> <type>bigint</type> <literal>DEFAULT</literal> <literal>0</literal>)
>> + <returnvalue>void</returnvalue>
>> + </para>
>>
>> Should we return the millseconds of waiting time? I think this
>> information may be useful for customer if they want to know how long
>> time it waits for for minitor purpose.
>
> Please, check it more carefully. In v17 timeout is in integer milliseconds.

I guess one of us misunderstand the other:( and I do didn't check the
code very carefully.

Acutally I meant the "return value" rather than function argument. IIUC
the current return value is void per below statement.

>> + <returnvalue>void</returnvalue>

If so, when users call pg_wal_replay_wait, they can get informed when
the wal is replaied to the target_lsn, but they can't know how long time
it waits unless they check it in application side, I think such
information will be useful for monitor purpose sometimes.

select pg_wal_replay_wait(lsn, 1000); may just take 1ms in fact, in
this case, I want this function return 1.

--
Best Regards
Andy Fan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2024-04-02 08:23:45 Re: using extended statistics to improve join estimates
Previous Message Alexander Korotkov 2024-04-02 08:08:17 Re: [HACKERS] make async slave to wait for lsn to be replayed