How can end users know the cause of LR slot sync delays?

From: Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: How can end users know the cause of LR slot sync delays?
Date: 2025-08-28 05:36:42
Message-ID: CAE9k0PkhfKrTEAsGz4DjOhEj1nQ+hbQVfvWUxNacD38ibW3a1g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

We have seen cases where slot synchronization gets delayed, for example
when the slot is behind the failover standby or vice versa, and the slot
sync worker has to wait for one to catch up with the other. During this
waiting period, users querying pg_replication_slots can only see whether
the slot has been synchronized or not. If it has already synchronized,
that’s fine, but if synchronization is taking longer, users would naturally
want to understand the reason for the delay.

Is there a way for end users to know the cause of slot synchronization
delays, so they can take appropriate actions to speed it up?

I understand that server logs are emitted in such cases, but logs are not
something end users would want to check regularly. Moreover, since logging
is configuration-based, relevant messages may sometimes be skipped or
suppressed.

Thanks & Regards,
Ashutosh Sharma.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhijie Hou (Fujitsu) 2025-08-28 06:17:23 RE: Fix replica identity checks for MERGE command on published table.
Previous Message Steven Niu 2025-08-28 05:22:51 Re: Avoid retaining conflict-related data when no tables are subscribed