[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