db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen <Oystein.Grov...@Sun.COM>
Subject Re: Not able to get in-place compression to release space to file system
Date Tue, 11 Mar 2008 08:58:54 GMT
Øystein Grøvlen wrote:
> 
> I have been experimenting a bit with in-place compression on a large
> table, but I have not been successful in getting it to give back space
> to the file system.  I have table that I have done a lot of bulk
> changes to over time.  It is now much smaller than it was at its peak
> size, but I am not able to reduce the size of the corresponding files
> by in-place compression.  My last attempt:

I have now deleted all records in the table, but inplace compress does 
still not release any pages:

ij> select conglomeratename, isindex, numallocatedpages, numfreepages, 
pagesize, estimspacesaving from new 
org.apache.derby.diag.SpaceTable('T') t order by conglomeratename;
CONGLOMERATENAME 
 
|ISIND&|NUMALLOCATEDPAGES   |NUMFREEPAGES        |PAGESIZE 
|ESTIMSPACESAVING
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
T 
                                                         |0     |1 
              |419741              |4096       |1719259136
X_I 
                                                         |1     |131 
              |20105               |4096       |82350080

2 rows selected


-- 
Øystein

Mime
View raw message