logoalt Hacker News

mb4nck • today at 8:23 PM • 1 reply • view on HN

For performance reasons, sequences have always been non-transactional in Postgres. This implies that they are not in the transaction log which is being replicated to standbys.

As I understand it, the new feature is not a continuous replication (for the above reason), but rather a one-off synchronization of the current sequence values of a leader to its followers, you'd need to run it again later for additional syncs.


Replies

mxey • today at 8:33 PM

> For performance reasons, sequences have always been non-transactional in Postgres. This implies that they are not in the transaction log which is being replicated to standbys.

This cannot be true because physical replication already supported sequences. Only the support for logical replication is new.