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

Andy Fan <zhihuifan1213@163.com>

From: Andy Fan <zhihuifan1213@163.com>

To: Alexander Korotkov <aekorotkov@gmail.com>

Cc: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, Kartyshov Ivan <i.kartyshov@postgrespro.ru>, Euler Taveira <euler@eulerto.com>, Thomas Munro <thomas.munro@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, Amit Kapila <amit.kapila16@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>, Peter Smith <smithpb2250@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2024-04-02T03:25:57Z

Lists: pgsql-hackers

Alexander Korotkov <aekorotkov@gmail.com> writes:

Hello,

>  
>  Did you forget to attach the new patch?
>
> Yes, here it is. 
>
> ------
> Regards,
> Alexander Korotkov 
>
> [4. text/x-diff; v17-0001-Implement-pg_wal_replay_wait-stored-procedure.patch]...

+        </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. 

-- 
Best Regards
Andy Fan

Commits

Ensure standby promotion point in 043_wal_replay_wait.pl
- 2520226c953c 18.0 landed
Minor cleanup related to pg_wal_replay_wait() procedure
- 85b98b8d5a48 18.0 landed
Adjust pg_wal_replay_wait() procedure behavior on promoted standby
- 867d396ccd2a 18.0 landed
pg_wal_replay_wait(): Fix typo in the doc
- 8036d73ae3d4 18.0 landed
Implement pg_wal_replay_wait() stored procedure
- 3c5db1d6b016 18.0 landed
- 06c418e163e9 17.0 landed
Revert: Implement pg_wal_replay_wait() stored procedure
- 772faafca1b2 17.0 landed
Call WaitLSNCleanup() in AbortTransaction()
- 74eaf66f988c 17.0 landed
Clarify what is protected by WaitLSNLock
- ee79928441e7 17.0 landed
Use an LWLock instead of a spinlock in waitlsn.c
- 25f42429e2ff 17.0 landed
Use the pairing heap instead of a flat array for LSN replay waiters
- bf1e65080629 17.0 landed
Minor improvements for waitlsn.c
- e37662f22158 17.0 landed
Make the order of the header file includes consistent
- 97d85be36544 17.0 cited