Hi, I'm trying to get rid of old crud (deleted and rejected tickets, mostly spam) in our RT-DB, and so use rt-shredder. Which seems to work fine, but is so slow that my best estimate for it to finish wiping ~80k tickets is "upwards of 6 months":
time ( rt-shredder --force --plugin "Tickets=query,(status = 'rejected' OR status = 'deleted') AND id <610000;limit,10") real 9m33.764s user 0m6.984s sys 0m0.708s Any hints on possibilities to speed this up? (rt-shredder from RT 3.8 (Debian), incl. RT-IR 2.4, postgres backend) Kind regards, robert -- // CERT Austria - Robert Waldner <wald...@cert.at> // http://www.cert.at/ - T: +43 1 5056416 78 // Eine Initiative der nic.at GmbH // http://www.nic.at/ - Firmenbuchnummer 172568b, LG Salzburg --------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Los Angeles - September, 2016
