couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benoit Chesneau <>
Subject Re: Why is the actual size of a database 4 times larger than the netto payload?
Date Wed, 24 Mar 2010 09:05:46 GMT
On Wed, Mar 24, 2010 at 10:02 AM, Roessner, Silvester
<> wrote:
> On, 24 Mar 2010, at 09:36, Jan Lehnardt [] wrote
>> Yeah, you'll want to run compaction to redice on-disk file size.
>> See for details.
> I stored each of the copies as a separat document with a unique ID.
> My goal was to estimate how much disk space my database will consume.
> So there are no old revisions to purge.
> I did a compaction already since I hoped CouchDB would compact anyway.
> But since there are no old revisions the database keeps at 0.9 GB.

Compact not only remove revisions but also holes in the b-tree. Also
make sure you use consecutive ids.

- benoit

View raw message