[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