[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