incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benoit Chesneau <bchesn...@gmail.com>
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
<silvester.roessner@vision.zeiss.com> wrote:
> On, 24 Mar 2010, at 09:36, Jan Lehnardt [jan@apache.org] wrote
>
>> Yeah, you'll want to run compaction to redice on-disk file size.
>> See http://wiki.apache.org/couchdb/Compaction 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

Mime
View raw message