[Bucardo-general] Bucardo too slow do start replicating big update

Kaveh Mousavi Zamani kavehmz at gmail.com
Thu Nov 3 00:06:58 UTC 2011


On Thu, Nov 3, 2011 at 12:39 AM, Michelle Sullivan <michelle at sorbs.net>wrote:

> 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.
>
>
Not specifically one day. It was just as a sample of how to clean the delta
table :).


> 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
> >
> >
>
> --
> Michelle Sullivan
> http://www.mhix.org/
>
> _______________________________________________
> 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/6865abd6/attachment.html 


More information about the Bucardo-general mailing list