[rt-users] Any way to speed up shredding?

[Robert Waldner]

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 <waldner at 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