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

Yan Chunlu springrider at gmail.com
Wed Dec 14 15:14:34 UTC 2011


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?   I straced
the process and found it seems need to query every record in
bucardo_delta table.

could not it just insert or update the record? if the pk is
duplicated, just ignore it or log it into conflicts.


More information about the Bucardo-general mailing list