Am 10.06.2016 um 12:02 schrieb 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)
There are some database indexes suggested: https://docs.bestpractical.com/rt/4.4.1/RT/Shredder.html#Database-Indexes I use just some if them, es they improve shredding tickets enough for me: CREATE INDEX SHREDDER_CGM3 ON CachedGroupMembers (Via, Id); CREATE UNIQUE INDEX SHREDDER_GM1 ON GroupMembers(MemberId, GroupId); CREATE INDEX SHREDDER_TXN3 ON Transactions(TYPE, OldValue); CREATE INDEX SHREDDER_TXN4 ON Transactions(TYPE, NewValue); Chris --------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Los Angeles - September, 2016
