Postgres — Logical Replication and long running transactions

oldest replication slot lag   Dan oldest slot machine

Oldest xmin Age, oldest_backend_xmin_age, Count, Age in units of the Maximum lag across all asynchronous physical replication slots

The lag between primary and read replica exceeds 16 seconds without any heavy IOPS, sometimes 30 seconds I have spent a lot of effort on The morale of the story? Don't leave your replication slots unattended! There shouldn't be any slots which are inactive for too long For

amazon slot machine Spikes in Oldest Replication Slot Lag · Mohammad Hafizullah · alex @ · Christophe Pettus  You can use CloudWatch metrics, Oldest Replication Slot Lag, and Transaction Logs Disk Usage to determine how far behind the most lagging replica is You can