Postgres — Logical Replication and long running transactions

Postgres — Logical Replication and long running transactions oldest replication slot lag High replica_lag means that the replica can't apply replication changes fast enough The total lag can be observed via replica_byte_lag metric, which has labels oldest replication slot lag Oldest Replication Slot Lag : The lagging size of the replica lagging the most in terms of write-ahead log data received Applies to

oldest replication slot lag Each read replica has its own physical slot on the source DB instance The slot keeps track of the oldest WAL that might be

bonus slot 100 di awal Replication lag is the delay between the time when data is written to the primary database and the time when it is replicated to the standby I have replication slots which are inactive and their xmin date is now a few days old This matches up with oldest replication slot lag metric