On Fri, Sep 16, 2011 at 05:12:48PM +0300, Michael Stepanov wrote: > Our RT3 system has Attachments table with size about 300GB. We'd like to > clean it by removing > old records with files. The rt-shreder can do this job properly I guess. > But there is no way > to specify query criteria there. Even direct delete query is failed.
rt-shredder allows query criteria. -kevin > Does somebody can suggest how to clean Attachments table? > > BTW, IMHO it's bad idea to store files in the database cause it isn't > scalable solution and > it's very difficult to upgrade/backup/restore DB.
pgp5grfn9XIGW.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011
