percona / roadmap

Public Percona Roadmaps
10 stars 1 forks source link

[K8SPG-606] Add support for delayed replica in PostgreSQL Operator #112

Open spron-in opened 3 months ago

spron-in commented 3 months ago

Community Note

Tell us about the feature

Delayed replication is the idea of applying time-delayed changes from the WAL. That is, a transaction that is committed at physical time {{X}} is only going to be visible on a replica with delay {{d}} at time {{X + d}}.

It is useful for disaster recovery purposes and provides much faster recovery compared to point-in-time.

Link to JIRA