couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Lehnardt <>
Subject Re: Compaction of new database
Date Mon, 07 Jul 2008 18:56:58 GMT

On Jul 7, 2008, at 20:38, Brad King wrote:

> Maybe I don't understand compaction, but based on what I've read this
> is meant to get rid of old doc versions, and essentially any
> fragmentation that has occurred. What I'm seeing is for a brand new
> database, I create approximately 300K documents and the size is 2.2GB.
> I then run a compact from Futon, and size drops to 414MB. Since this
> is a new database, which should only have one version of each
> document, why the dramatic size change?

CouchDB trades disk space for read and write-speed as well. Not only
for consistency and having old revisions around. When you bulk insert
all docs, or a bunch of docs at a time, you see less usage than when
you do single inserts.


View raw message