[Bucardo-general] "swap" sync took [1962 s] to Insert 1066 records....

[Greg Sabino Mullane]

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
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20111214/6e58b748/attachment.bin