[Bucardo-general] b5: delta_ rows not being deleted

Greg Sabino Mullane greg at endpoint.com
Tue Feb 12 19:10:42 UTC 2013

On Sat, Dec 08, 2012 at 12:08:32AM -0500, Bill McGonigle wrote:
> b5 is running vac as expected, just nothing's being cleaned up.  I
> didn't see in the .pm where the delta_ delete is supposed to run.
> Maybe somebody can clue me in on where that happens.
> If it's not yet implemented, a query to delete 5 minute old deltas
> with no txntime match in stage_ ought to be OK, right?

No, that would delete rows not yet replicated. The vac process removes 
delta rows that *do* have a matching txntime, where the number of 
matches equals the number of syncs replicating that table.

The relevant code in the latest HEAD is at line 6749:

$SQL = q{SELECT bucardo.bucardo_purge_delta('45 seconds')};

The actual function is in bucardo.schema: that's what does the actual 
work in deleting old rows.

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/20130212/8cb73fe0/attachment.sig>

More information about the Bucardo-general mailing list