[rt-users] Removing tickets from RT/making the RT database smaller

[Vivek Khera]

>>>>> "DA" == Dave Alton <da_19782000 at yahoo.com> writes:

DA> database, but because of the size of the DB, if causes
DA> the machine to become unresponsive for about 10
DA> minutes. 

 ;-)  use postgres instead  ;-)


DA> We would like to purge all tickets in a resolved state
DA> that have not been updated for 30+ days, as that would
DA> remove about 85,000 tickets and make the RT database

Well, if you can do an update in sql directly to set the status of the
tickets to 'dead' then you can use the remove dead tickets scripts
(posted here several times) to actually remove them from the
database.  In postgres, I just set up foreign keys to cascade the
delete automatically, so I don't need such a script.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/