On Friday, March 13, 2026 7:36 PM Kuroda, Hayato/黒田 隼人 <[email protected]> wrote:
> Thanks for updating the patch. Comments for v12-0002. Thanks for the comments. After some off-list discussion with Amit, we agreed that further analysis is needed, which means rescheduling this feature for the next release. The main issue requiring analysis is how to reduce the impact of invalidations that can occur once the sequence synchronization worker begins modifying pg_subscription_rel regularly. The current patch updates pg_subscription_rel only every 30 seconds, which seems acceptable for an initial version. However, there are other potential approaches worth exploring, such as: 1) adding a subscription option to let users control the update frequency, or 2) updating the catalog only after modifying a specific number of sequences. It would also be worthwhile to examine other modules for similar issues and their solutions. For example, autoanalyze and autovacuum also modify the catalog regularly. We should investigate whether they face the same invalidation challenges and how those challenges are addressed. Overall, we will continue working on this to improve the patch set, but will schedule it for PG20. Best Regards, Hou zj
