[Bucardo-general] delete or empty delta table
josh at endpoint.com
Mon Feb 22 20:22:31 UTC 2010
On Mon, Feb 22, 2010 at 10:18:44AM +0800, ellisa setia wrote:
> is that ok if i delete or empty delta table? and what will happen after i
> empty delta table?
I assume you're asking because you've got a really big delta table. That's the
table where bucardo tracks what has changed in your database, and what it
needs to replicate. Make sure you vacuum it regularly, and if you find it's
full of rows, you can try the bucardo_purge_delta() function. It takes one
argument, an interval value, and will remove from the delta table all rows
older than the interval, that have already been replicated.
Josh Tolley josh at endpoint.com 801-987-0252
End Point Corporation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100222/b571ffa2/attachment.bin
More information about the Bucardo-general