[Bucardo-general] extremely large bucardo.bucardo_delta table
michelle at sorbs.net
Fri Mar 4 06:45:22 UTC 2011
Martin Atukunda wrote:
> I have a setup here with two master databases. the main database has a bucardo.bucardo_delta table that has 174,377,043 rows in it.
> This table is vacuumed regularly, and is still quite large.
> last txntime is: 2011-03-04 12:33:51.697631+078:41
> earliest is: 2010-12-10 15:48:39.186257+07
> I rebuilt the replication system on 2011-01-15.
> Is it safe for me to remove the older rows from the bucardo.bucardo_delta table?
You didn't set up the cronjob to remove them then?
This is what you need on all servers:
*/15 * * * * /usr/local/bin/psql -X -q -d replicateddatabase -U pgsql -c
"SELECT bucardo.bucardo_purge_delta('10 minutes'::interval)"
More information about the Bucardo-general