pgsql: Fix excessive logging in idle slotsync worker. - Mailing list pgsql-committers

From Amit Kapila
Subject pgsql: Fix excessive logging in idle slotsync worker.
Date
Msg-id E1wC98L-000jtI-1a@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix excessive logging in idle slotsync worker.

The slotsync worker was incorrectly identifying no-op states as successful
updates, triggering a busy loop to sync slots that logged messages every
200ms. This patch corrects the logic to properly classify these states,
enabling the worker to respect normal sleep intervals when no work is
performed.

Reported-by: Fujii Masao <masao.fujii@gmail.com>
Author: Zhijie Hou <houzj.fnst@fujitsu.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Reviewed-by: shveta malik <shveta.malik@gmail.com>
Backpatch-through: 17, where it was introduced
Discussion: https://postgr.es/m/CAHGQGwF6zG9Z8ws1yb3hY1VqV-WT7hR0qyXCn2HdbjvZQKufDw@mail.gmail.com

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/91741b7cb7b5e0f0eb5100a548798b5a395cd3b5

Modified Files
--------------
src/backend/replication/logical/slotsync.c | 17 +++++++++++++++--
1 file changed, 15 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: David Rowley
Date:
Subject: pgsql: Improve various new-to-v19 appendStringInfo calls
Next
From: Amit Kapila
Date:
Subject: pgsql: Fix capitalization in publication describe output.