[Bucardo-general] Fwd: Syncing smaller batches

Greg Sabino Mullane greg at endpoint.com
Tue Nov 3 14:46:43 UTC 2015

On Tue, Nov 03, 2015 at 09:22:34AM -0500, Ioana Danes wrote:
> I installed the latest version 5.4.1 and it does look a little faster but
> still not fast enough for my volume test.

Glad things are improved, but the enhancements I was referring to are 
not in a released version yet - one would need to git checkout to 
see them.

> I watched postgres and noticed that the bottleneck is the function 
> bucardo.bucardo_delta_check(text, text). I changed it a little to check 
> if the latest record in delta table exists in the track table which is 
> very fast and now the performance looks a lot better.:

Excellent, thanks for that! I will look it over and try it out soon.

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: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20151103/241cfa73/attachment.sig>

More information about the Bucardo-general mailing list