db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Behaviour of SYSCS_COMPRESS_TABLE
Date Thu, 02 Jun 2005 15:58:21 GMT
non-leaf pages are also reclaimed when they are empty as part of merge
process when last leaf page pointed at is reclaimed.

Øystein Grøvlen wrote:
>>>>>>"MM" == Mike Matrigali <mikem_app@sbcglobal.net> writes:
> 
> 
>     MM> Derby will also reclaim space automatically in btree indexes for this
>     MM> case as long as all the old rows on a given leaf are deleted and
>     MM> the background process gets a chance to get a table level lock
>     MM> at some point - the current algorithm requires a table level lock
>     MM> to do the index management to delete an entire leaf from the tree.
> 
> What about non-leaf pages of the B-Tree?
> 


Mime
View raw message