pgsql: In caught-up logical walsender, sleep only in WalSndWaitForWal() - Mailing list pgsql-committers

From Noah Misch
Subject pgsql: In caught-up logical walsender, sleep only in WalSndWaitForWal()
Date
Msg-id E1jSOaq-0000rX-HQ@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
In caught-up logical walsender, sleep only in WalSndWaitForWal().

Before sleeping, WalSndWaitForWal() sends a keepalive if MyWalSnd->write
< sentPtr.  When the latest physical LSN yields no logical replication
messages (a common case), that keepalive elicits a reply.  Processing
the reply updates pg_stat_replication.replay_lsn.  WalSndLoop() lacks
that; when WalSndLoop() slept, replay_lsn advancement could stall until
wal_receiver_status_interval elapsed.  This sometimes stalled
src/test/subscription/t/001_rep_changes.pl for up to 10s.

Reviewed by Fujii Masao and Michael Paquier.

Discussion: https://postgr.es/m/20200418070142.GA1075445@rfd.leadboat.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f246ea3b2a5e0b75e44f0f18157c4b5e10b5547f

Modified Files
--------------
src/backend/replication/walsender.c | 20 +++++++++++---------
1 file changed, 11 insertions(+), 9 deletions(-)


pgsql-committers by date:

Previous
From: Andrew Gierth
Date:
Subject: pgsql: Fix error case for CREATE ROLE ... IN ROLE.
Next
From: Peter Geoghegan
Date:
Subject: pgsql: Fix minor nbtree page deletion buffer lock issue.