[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