Re: size of DB files not decreasing

[Quanah Gibson-Mount <quanah@zimbra.com>]

--On September 29, 2008 9:19:00 PM +0530 Nikhil Mishra <ls.niks@gmail.com> 
wrote:

> hello all ,
>
>
> While deleting the entries from openldap- Database I see that there is no
> change in the file size .
> I  did an external checkpoint  using db_checkpoint -1 and db_archive -d .
> The changes are reflected fro an add operation but it is not reflected
> for delete .
>
> I have a requirement where I need to externally poll the size of DB for
> openldap .
> But delete operation is not making any changes to actual DB file size .
> I am not sure if its a BDB limitation or something to do with the way
> openldap is being configured .
>
> Please help in understanding .

This is fairly common with all databases -- Deleted data is marked, but the 
space is not recovered without reloading the DB.  What happens is the next 
time you add a new entry, that region is reused for the new entry, so the 
DB also won't grow until you exceed what you've deleted.

--Quanah

--

Quanah Gibson-Mount
Principal Software Engineer
Zimbra, Inc
--------------------
Zimbra ::  the leader in open source messaging and collaboration