3 ms·
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 expl
by jeffbee 5y ago
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.
- rigaspapas 5y agoThat'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.