[Bucardo-general] Questions About Using Bucardo

[Rosser Schwarz]

On Tue, Jul 20, 2010 at 9:46 AM, Greg Sabino Mullane <greg at endpoint.com> wrote:
>> 3. Did Anyone Have Speed/Latency Issues With Bucarrdo ?

> Yes. As stated above, all replication systems will add load to the
> database and slow things down. How slow and how much load depends
> a great deal on how many tables you are replicating and how much
> data is changing, as well as the network between the different
> servers.

A useful tactic to mitigate the overhead of replication is to keep the
logical groups of tables that are replicated together (a "herd" in
Bucardo parlance) as small as possible.  As Greg mentioned, you'll
want to replicate tables interrelated by foreign keys together, in
order to maintain referential integrity.  If your schema allows for
it, keeping your herds limited to just those interrelated tables will
mean Bucardo needs to do much less work to replicate individual tuples
in one of those sets.

In practice, the difference between a large number of herds with just
a few tables each, versus a few herds (or even one) with a large
number of tables can be significant.

rls

-- 
:wq