http://www.perlmonks.org?node_id=474852


in reply to Remember to re-org
in thread Using Perl to clean up DBs?

On the other hand, they are log tables, the empty space will be reused to store new rows, so the space does not really go wasted. Reorganizing would just take space away from a table whose natural growth will see it extend itself again soon.

Replies are listed 'Best First'.
Re^2: Remember to re-org
by mugwumpjism (Hermit) on Jul 14, 2005 at 23:47 UTC

    It really depends on the RDBMS and the type of the table. There is no absolute "this is what happens to space freed by deleted rows". It's something that you need to find out about, preferably before all of your table space is gone and you don't know why. 

    $h=$ENV{HOME};my@q=split/\n\n/,`cat $h/.quotes`;$s="$h/."
."signature";$t=`cat $s`;print$t,"\n",$q[rand($#q)],"\n";

    [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom