News for hackers. Stuff that matters.
Re:Zero downtime Postgres migration, done right by jeffbee on Friday June 11, 2021 @03:06PM (#27477266)
Bucardo has no performance impact, it just adds a trigger to every mutation. Negligible!

I really think articles of this kind are not useless, but need to explicitly narrow their audience to set expectation at the start. This particular topic is PG replication for users who aren't very sensitive to write latency.

Re:Zero downtime Postgres migration, done right by rigaspapas on Tuesday June 15, 2021 @06:14AM (#27513216)
That's a good point. We mention latency as "replication lag" and we have devoted a paragraph to the drift that comes as the result of this latency. In our case, we measured the latency to be <1s, and it was totally acceptable. As for the performance, triggers can become a problem with enough write traffic. In a different use case, Bucardo would be eliminated from a potential solution due to this.