[Bucardo-general] indirect bucardo problem - stuck triggers?

Paul Theodoropoulos paul at anastrophe.com
Mon Apr 28 20:47:53 UTC 2014

On 4/27/14, 11:27 AM, Greg Sabino Mullane wrote:
> On Fri, Apr 25, 2014 at 12:46:55PM -0700, Paul Theodoropoulos wrote:
>> INFO:  vacuuming "bucardo.bucardo_truncate_trigger"
>> INFO:  "bucardo_truncate_trigger": found 623880 removable, 181642
>> nonremovable row versions in 1111573 pages
> I think there are two things going on here: first, a sync is failing,
> but does make it to the update bucardo_truncate_trigger step,
> so the table becomes super bloated from all the updates. Hard to believe
> it gains that much overnight, but it's a theory. Second, something is
> off with your vacuum process as shown by the other email.
Yeah, it surprised me too - but those 623,880 clogged up triggers 
amounted to several gig of bloat to the db.

Paul Theodoropoulos

More information about the Bucardo-general mailing list