[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