The data file size do not shrink down when delete from ravendb

Question

I used the following code to delete documents from RavenDB. At the bottom of Raven UI, I can see the number of documents decrease from 3,000,000 to 2,000,000. But the size of the "Data" file does not shrink down. It is always about 100G.

            store.DatabaseCommands.DeleteByIndex("Sagas/ByStarted", new IndexQuery
            {
                Query = "Started:{00010101000000 TO 20130101000000}",
            });

Server Build #960, Client Build #960 Please help ...

Answer 1

That is by design. We don't give out space back to the OS by default. We keep and reuse that space again as needed. If you really need to trim the file size, you would need to compact the db, but that is an offline operation.