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-000jtE-1T@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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/85c17f612af7b9c47a9828805686f0dd2433cdf1

Modified Files
--------------
src/backend/replication/logical/slotsync.c | 16 ++++++++++++++--
1 file changed, 14 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.