vyruss
Joined 25 karma
Senior Principal Engineer @ Deriv
- vyrussTrue, but Bucardo is trigger-based and does not use WAL-based logical replication, and is unmaintained. There is also a world of difference in performance between them.
- pgactive has limitations with not supporting DDL, sequence management, column and row filtering, conflict and exception handling, incompatibility with native logical replication, etc. The license is also different (Apache 2.0 for pgactive vs PostgreSQL for Spock). Most importantly, it's not "supported anywhere" by AWS, just on RDS.
- Local write latency in a geo-distributed database is also important for some use cases.
- major? More like none.
- Thank you so much for your interest in my FOSDEM talk!
Slides link: https://fosdem.org/2020/schedule/event/postgresql_the_state_...
Slideshare: https://www.slideshare.net/vyruss000/the-state-of-full-text-...
Video will appear under these URLs after mirrors are synced:
MP4: https://video.fosdem.org/2020/H.2214/postgresql_the_state_of...
WebM: https://video.fosdem.org/2020/H.2214/postgresql_the_state_of...