couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Davis <>
Subject Re: Why is the actual size of a database 4 times larger than the netto payload?
Date Wed, 24 Mar 2010 14:57:37 GMT
On Wed, Mar 24, 2010 at 5:40 AM, Roessner, Silvester
<> wrote:
> On Wed, Mar 24 2010 at 10:06 Benoit Chesneau wrote:
>> Compact not only remove revisions but also holes in the b-tree. Also
> make sure you use consecutive ids.
> I tried it with consecutive ids as well but I the database is still 4
> times as big as the payload.
> I think I must live with this fact.
> Silvester

The consecutive id's only make a difference when using _bulk_docs
because it removes the holes in the append only btree.

Did you check to see what the file size was after a compaction? It
should be significantly better.

Paul Davis

View raw message