db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Not able to get in-place compression to release space to file system
Date Tue, 11 Mar 2008 22:27:26 GMT
Is the data such that you can post the database?  If so does the db
zip to a managable size?

Have your recent attempts at in-place compress been single user?

What version are you using?


Øystein Grøvlen wrote:
> Ø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
> 
> 


Mime
View raw message