Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: 
 <CAAOi-OEBZye==s9uE6amc2_ojzTPbf4SjW6OM1p=PjijpO5GXw@mail.gmail.com>
References: 
 <CAAOi-OFMhQ0X3iEUC6T0fSdwJLV20Huj4tnJZBSfZ5Q5TtEx7g@mail.gmail.com>
 <CAN-3CBK4OQ5jJDa3ojfxkt=nN0OVpX8JnFUp21-AkgJzLTtN5g@mail.gmail.com>
 <CAAOi-OFWeYtZbLfLbsUV9Egk3j6kFtVa2t9urZu95KH3buLJdw@mail.gmail.com>
 <CAMiZLn07ru9fUgxsmtCsT2rG8ShfRrD=1bpLRN-f1YGG8athTA@mail.gmail.com>
 <CAAOi-OGEvWZrEkDyrxr1W0FKmA=Feso=smesQYU9_joARtSiqQ@mail.gmail.com>
 <CAN-3CBK3SCx7Y5K1oEC+XfzgY2B+-9_0c90m6npM9GkE_myu0g@mail.gmail.com>
 <CAAOi-OEBZye==s9uE6amc2_ojzTPbf4SjW6OM1p=PjijpO5GXw@mail.gmail.com>
From: Jason Smith <jhs@iriscouch.com>
Date: Fri, 16 Mar 2012 09:52:52 +0000
Message-ID: 
 <CAN-3CBKN9EF-T5gNg59JPpz+=oPVXUXDVr+m+JOYcPMeRwUYog@mail.gmail.com>
Subject: Re: Size of couchdb documents
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8

On Fri, Mar 16, 2012 at 9:10 AM, Daniel Gonzalez <gonvaled@gonvaled.com> wrote:
>>
>> Hi, Daniel. That's great news! Also, I have an update from a CouchDB 1.2.0
>> test.
>>
>> I have a database here with 10 million documents, most several KB of
>> English text. upgrade to version 1.2 changed the database size from
>> 38GB to is 9.2GB, or now 0.94 KB per document.
>>
>
> That is interesting. Is CouchDB reducing the size of your stored data?
> Compression? Or is the average size of your input data smaller than 0.94KB?
> (I am not sure what "most several KB" means)

Well, you busted me. I do not know the average size of the documents
offhand, but I suspect it is much greater than 400 bytes, because many
of the documents are a few KB (maybe 1kb-5kb) of text strings.

But, yes, CouchDB 1.2 stores data compressed on the disk. I am using
the Snappy option for the minimal CPU hit.

http://code.google.com/p/snappy/

-- 
Iris Couch