[Bucardo-general] Bucardo too slow do start replicating big update
Kaveh Mousavi Zamani
kavehmz at gmail.com
Wed Nov 2 16:04:10 UTC 2011
Cleaning the bucardo table by a command like in the master database might
help a little.
SELECT bucardo.bucardo_purge_delta('1 day'::interval);
Also, replications time depends a lot on network speed you have between
master and slave.
Regards
Kaveh
On Wed, Nov 2, 2011 at 11:49 PM, Gustavo Tonini <gustavotonini at gmail.com>wrote:
> Hello people,
> I have a problem on a 41K tuples update. Bucardo takes about 30 minutes
> processing I don't know what.
> See the log:
>
>
> [Tue Nov 1 23:41:55 2011] KID No conflict, target only for
> public.wms_ent_sai.id_geral: 2000004951123
> [Tue Nov 1 23:41:55 2011] KID Action summary: 1:41362 2:11
> [Wed Nov 2 00:24:33 2011] KID [1/41373] public.wms_ent_sai INSERT source
> to target pk 1000005861194
>
>
> Is there anything I can do?
>
> Regards,
> Gustavo.
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
--
The GNU Operating System
Free as in Freedom
http://www.gnu.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20111103/7e7f46d2/attachment.html
More information about the Bucardo-general
mailing list