On Fri, Jul 17, 2026 at 11:03 AM Tom Lane <[email protected]> wrote: > > Could we, on detecting the race condition problem, wait awhile > to see if it resolves? >
Yes, we can do that. But it may not be completely reliable because sequencesync worker can exit and restart due to some ERROR. In those cases, again we can miss synchronizing the latest value of sequence. > > Or simply exit and let the REFRESH be > a no-op? > But this will bring us to where we are without commit f38afa4ab. We wanted to make users aware that REFRESH may not have refreshed all sequences, so do you think a LOG/WARNING with a hint be better option or we can always points user to our documentation [1] (Refreshing Out-of-Sync Sequences) where we documented how ensure sequences are synced? [1] - https://www.postgresql.org/docs/19/logical-replication-sequences.html#LOGICAL-REPLICATION-SEQUENCES -- With Regards, Amit Kapila.
