[Bucardo-general] What could be a cause for so big delay?

[Greg Sabino Mullane]

> While experimenting with Bucardo, I wrote a java program inserted about 3000
> records in a loop. I was interesting how long it would take for Bucardo to
> replicate the rows. It took 21 sec  to insert. But it took more then half an
> hour  to replicate!!!!
> I tried to watch a log during that time. I am definitely not fluent in
> reading the Bucardo log.  To me it was doing nothing for the whole half an
> hour, then suddenly awoke and inserted all records at once.

Sounds to me like the sync was not "kicked" until that point. What kind of sync
is it, and was there a trigger on the table in question? If there was not, then
the rows will not be replicated until either it is manually kicked via
bucardo_ctl, or the timeout is reached for the sync in question (the value of
'checktime').

-- 
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: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090309/fecaaa8f/attachment.bin