3 ms·
Could any contributers to Patroni opine on what impact Postgresql 10's logical replication will have? Are you excited about it?
by Dowwie 10y ago
Could any contributers to Patroni opine on what impact Postgresql 10's logical replication will have? Are you excited about it?
- hintbits 10y agoWhile logical replication is a long-awaited and exciting feature, I'd use it to replicate only a subset of my database, not as a replacement for HA. At present, it cannot follow the master in a physical replication after promotion (basically, you have to initialize your logical replicas from scratch), and it has a bigger lag then the physical replication, especially for long-running transactions, as one has to wait until the commit before sending the data. Nevertheless, I think Patroni can help configuring logical replicas that will never be part of the HA (if one can tolerate reinitializing logical replicas after failing over). Pool requests are welcome!