4 ms·
I don't think the post informs on Physical and Logical replication that well. Most database systems of adequate budget and maturity implement both, for various
by fdr 6y ago
I don't think the post informs on Physical and Logical replication that well.
Most database systems of adequate budget and maturity implement both, for various reasons.
- rattray 6y agoInteresting, thanks. Yeah I was surprised to hear his skepticism of logical replication, but I've never operated it in production before. Curious for resources on that.
- fdr 6y agoYou mean physical, re: skepticism. Just different things. Bulky for "CREATE INDEX" or "VACUUM", but also faster for a lot of things (no decoding) and able to more naturally deal with incomplete transactions. A good way to get a feel for that is to read how people compare using either one for proprietary databases that have both.