[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