[Bucardo-general] child_q_ relations linger & entries in q table with no updates/inserts/deletes
Greg Sabino Mullane
greg at endpoint.com
Tue Jan 11 03:15:41 UTC 2011
The q stuff gets moved by the bucardo_purge_q function to
the master_q table, which then gets sent to child
tables in the freezer schema. If you don't care about
this old data (and many do not), you can simply drop
all the child_q_* tables.
> ... un-purged q table entries. They have NULL values for
> 'started' or 'aborted', so the bucardo_purge_q_table
> function doesn't see them, but they also don't have
> any 'updates', 'deletes', or 'inserts', which seems odd.
Odd, that would seem to indicate a controller starting
a q entry and a kid never picking it up. It should be
safe to nuke older ones, and automate that, by using
the cdate column.
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110110/4f55be61/attachment.bin
More information about the Bucardo-general
mailing list