[Bucardo-general] Bucardo too slow do start replicating big update
Michelle Sullivan
michelle at sorbs.net
Wed Nov 2 16:39:04 UTC 2011
Kaveh Mousavi Zamani wrote:
> Cleaning the bucardo table by a command like in the master database
> might help a little.
>
> SELECT bucardo.bucardo_purge_delta('1 day'::interval);
One day? I run mine every 10 minutes.
Michelle
>
> 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 <mailto: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 <mailto: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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
--
Michelle Sullivan
http://www.mhix.org/
More information about the Bucardo-general
mailing list