[rt-users] RTx-shredder with a very large database

[Vivek Khera]

On Feb 27, 2006, at 3:17 PM, Schultz, Eric wrote:

>>
>> You mean you want it to take less than roughly 6.8 months at
>> 24x7?!  :)
>>
>> duncan
>> _______________________________________________
>
> As the number of tickets in the database decreased, I am sure that the
> execution time would speed up in proportion.  It's those first 100K or
> so that you have to worry about :-)
>

you assume the tables actually physically shrink upon row deletes.   
This is not true for MySQL InnoDB tables nor for Postgres tables  
without further maintenance.