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

Greg Sabino Mullane greg at endpoint.com
Sun Apr 27 18:27:46 UTC 2014

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.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140427/1c7df1b5/attachment.sig>

More information about the Bucardo-general mailing list