Hello,
I was looking at Derby-606 and was able to reproduce the bug.
I am working with a table of 30 million rows of the schema mentioned in
the JIRA entry.
I have a query regarding the size of the table before and after
INPLACE_COMPRESS_TABLE command.
After creating the table and inserting the 30 million records, a simple
'du -sk' shows the size as,
12008738 testdb
I exeucted INPLACE_COMPRESS_TABLE through ij and the size returned from
the same command is,
12020239 testdb
Since, I have not performed any deletes, the reduction in the size is
not expected. ofcourse, the testdb directory does not include derby.log.
so, I am wondering about the little increase in the size. Is it in the
form of some other logs ? Can someone throw some light on this increase
in size ??
I would also appreciate any additional information on
INPLACE_COMPRESS_TABLE.
TIA
Mayuresh,
