[Bucardo-general] delete or empty delta table

[Joshua Tolley]

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?                                                         
>                                                                               
>    thx                                                                        

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
http://www.endpoint.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100222/b571ffa2/attachment.bin