Alex Georgiev

Author profile

Alex Georgiev

404 bio not found

@alexgeorgiev17SofiaWebsiteView on DEV

Articles by @alexgeorgiev17

Browse the latest writing surfaced through DevArt.

PostgreSQL 19's sequence replication only catches up when you tell it to
#postgres#database#devops#performance

PostgreSQL 19's sequence replication only catches up when you tell it to

PostgreSQL 19 RC1 can replicate sequence values to a logical subscriber, closing a long-standing failover gap. I measured it: an instant match on subscribe, then a frozen value through 700 more replicated rows until I ran REFRESH SEQUENCES, and a promotion I did properly still hit the exact duplicate-key error the feature is meant to prevent.

Alex GeorgievAlex Georgiev8 min read
11 reactions3 commentsRead full article
alexgeorgiev17 developer articles | DevArt