Ø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
