[rt-users] Cleaning Attachments
Kevin Falcone
falcone at bestpractical.com
Fri Sep 16 10:48:10 EDT 2011
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110916/f3e8da46/attachment.sig>
More information about the rt-users
mailing list