[Bucardo-general] multiple syncs on one database?

Greg Sabino Mullane greg at endpoint.com
Fri Oct 31 17:44:19 UTC 2014

On Mon, Sep 22, 2014 at 10:52:00AM -0700, Paul Theodoropoulos wrote:

Sorry for the delay, this one slipped off my radar until today's 
email cleanup.

> What I'm wondering is, could I break up the sync of those hundreds
> of tables that are in one db into separate syncs for say each ten
> tables? And more importantly - would there be any value in this -
> would having separate syncs make the each sync iteration a smaller
> 'chunk' which bucardo could chrew through more effectively, and
> resolve conflicts more efficiently?

As long as the tables are not logically linked (e.g. with foreign 
keys), you can break them apart any way you like. Using smaller 
syncs *may* help in this case, but it really depends on where all 
the time is being taken. Certainly, smaller syncs will reduce the 
time taken to run, and thus reduce the chance of serialization 
errors. Just how long does the full sync take?

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20141031/da3ca14b/attachment.sig>

More information about the Bucardo-general mailing list