On Tue, 17 Nov 2020, Ružica Prljević wrote:

We have Bucardo 5.5.0, and following set up:
bucardo set vac_run=2
bucardo set vac_sleep=8

VAC daemon should trim bucardo delta and track tables every 2 minutes in
this case from my understanding of Bucardo.

Our client wants to know why we do not implement following cron job:
*/5 * * * * /usr/sbin/bucardo purge all -verbose >/dev/null 2>&1

I have read through commands and documentation and cannot find any upside for using bucardo purge -all.

Can you please tell me if this command does something that VAC daemon doesn't?

Rose,

They look about the same to me: they both call the PostgreSQL function bucardo_purge_delta(text) so they do the same work.

The main difference is that vac_run calls it with argument '45 seconds', so it only cleans up transactions older than 45 seconds ago, while `purge all` calls it with argument '1 second', so it will purge almost all transactions.

In my mind you are already doing it a good way by using the vac_run facility.

Jon


--
Jon Jensen
End Point Corporation
https://www.endpoint.com/
_______________________________________________
Bucardo-general mailing list
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general

Reply via email to