On Thu, Sep 19, 2013 at 12:59:55PM -0700, Paul Theodoropoulos wrote: > Eliding lots of repetitious log output, the times are bothersome: > > start Bucardo: > (23733) [Thu Sep 19 12:12:02 2013] MCP Starting Bucardo version 5.0.0 > Almost ten minutes later, Bucardo begins inspecting the local db > groups on one dbgroup: > (23734) [Thu Sep 19 12:21:31 2013] MCP Inspecting source table > "public.alarm_notification_history" on database "local_trumgr_group" > Bucardo goes quiet again, then begin inspecting another dbgroup > seven minutes later:
Yeah, that's pretty extreme. Even with an insane number of tables and/or columns and/or targets, it should not be taking that long. So Bucardo is doing nothing at all for those first ten minutes according to the logs? Can you check the database logs and see if there is any query that might be extra-long running or blocked? Barring that, you might try stracing the MCP process during those gaps and seeing if you can figure out exactly what it is doing. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
