RE: [PATCH] Support automatic sequence replication

On Friday, March 13, 2026 7:36 PM Kuroda, Hayato/黒田 隼人 <kuroda.hayato@fujitsu.com> 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