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
www.anastrophe.com
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
