[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