I always wondered why sequence numbers weren't replicated, it added another step to the stress of upgrading via pg_backup but thanks for adding it to PG19!
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.
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.