[Bucardo-general] bucardo_delta contains over 24 million rows, cant purge
John Kelly
jtkells at gmail.com
Fri Oct 2 15:18:18 UTC 2015
Postgresql 8.4.20 on Ubuntu 10
bucardo_version = 4.5.0
master with two slaves
on master, bucardo_delta contains over 24 million rows. Bucardo very slow.
How can I clean up this may rows in bucardo_delta?
slaves:
agis_slave and agis_slave2
Note: agis_slave2 no longer exists
bucardo_deleta_targets show
211;"agis_slave" "2012-11-27 13:24:09.434827-05" (cdate)
100;"agis_slave2" "2013-09-16 14:21:37.63155-04" (cdate)
bucardo.bucardo_track
33,324;"agis_slave" "2014-01-21 11:22:08.274938-05" (tnxtime)
bucardo.bucardo_delta;
count
----------
24,810,406 records
bucardo_delta min max tnxtime;
min | max
-------------------------------+-------------------------------
2014-01-21 11:22:08.274938-05 | 2015-10-02 10:34:26.487373-04
select bucardo.bucardo_purge_delta('120 minutes'::interval)
returns
"Rows deleted from bucardo_delta: 10977 Rows deleted from
bucardo_track: 1131"
How can I purge these records in bucardo_delta and remove agis_slave2
records
Thanking you in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20151002/dc7745ce/attachment.html>
More information about the Bucardo-general
mailing list