Hi Deepak,

Some more time would have to be spent to explain this in full detail.

In a nutshell, deleted space is not immediately reduced to a minimum size because inserts are more regular. If you want to minimize your database structure after extensive updates, you can call OPTIMIZE (ALL).

Hope this helps,

Christian

On Mon, Feb 5, 2024 at 1:09 PM Deepak Dinakara <deepukalmane@gmail.com> wrote:

Hi,
I wanted to understand more on how deleting documents impact the storage layout.
I did go through https://docs.basex.org/wiki/Storage_Layout but didn't find all the required information.
I observed that size of files like "txt.basex" and "atv.basex" doesn't shrink on deleting documents.
Is that expected?

PS: Thanks for the great product.

Thank you,
Deepak