[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
> 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...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general