[Bucardo-general] "swap" sync took [1962 s] to Insert 1066 records....
Greg Sabino Mullane
greg at endpoint.com
Wed Dec 14 15:37:06 UTC 2011
On Wed, Dec 14, 2011 at 11:14:34PM +0800, Yan Chunlu wrote:
> the network latency is 200ms. I have tried "pushdelta" which is
> quite fast. it could handle millions records within minutes. but why
> does "swap" so slow? is there any chance to optimize it?
Yes: see Bucardo5. Should be much, much faster.
> could not it just insert or update the record? if the pk is
> duplicated, just ignore it or log it into conflicts.
No, it's not that easy, if you mean upserting the records into
bucardo_delta. We tried that before, and it slowed down access
to the triggered table too much.
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20111214/6e58b748/attachment.bin
More information about the Bucardo-general