From user-return-15279-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Tue Mar 15 18:54:08 2011 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 79920 invoked from network); 15 Mar 2011 18:54:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 15 Mar 2011 18:54:08 -0000 Received: (qmail 43349 invoked by uid 500); 15 Mar 2011 18:54:06 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 43314 invoked by uid 500); 15 Mar 2011 18:54:06 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 43306 invoked by uid 99); 15 Mar 2011 18:54:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Mar 2011 18:54:06 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of email.workbench@gmail.com designates 209.85.161.52 as permitted sender) Received: from [209.85.161.52] (HELO mail-fx0-f52.google.com) (209.85.161.52) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Mar 2011 18:53:58 +0000 Received: by fxm6 with SMTP id 6so1107000fxm.11 for ; Tue, 15 Mar 2011 11:53:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; bh=eavE2JEFxkS5x2MiyvaEIOpv4qA32SPWKDcTKa1SziE=; b=llFyseDM/AUEs7G4kT5mqgkAlxWzolmBDlDBsi4vJMf/h70hILAbl9SNk9PJFf2V6k mfzBxy2UnFeffACu+Haki+Wq+C92DtWoklEkcd1keV7ZPdBHLDe0hMTgw9pocIHMR9zI BKJ0nPrHL7vbW4lROY98oGEiV4CqT1tFFCAdQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; b=FkXs52LPpWi4165rRdKNe5zxIhOtQXPDjqBdXGeiMysJI+9a79vn3Ndef13Bh00VeI XZD1vwTVV5ihBDDXIMQlTLO20NlqbW814Y8/Otqdseh7sagkzeDet/UPHN29porS3Zcz sVwGiII1lBnCzSUJA4ccjB/q5qwutklk5MJdI= MIME-Version: 1.0 Received: by 10.223.81.79 with SMTP id w15mr4436800fak.12.1300215197960; Tue, 15 Mar 2011 11:53:17 -0700 (PDT) Sender: email.workbench@gmail.com Received: by 10.223.147.129 with HTTP; Tue, 15 Mar 2011 11:53:17 -0700 (PDT) In-Reply-To: References: Date: Tue, 15 Mar 2011 14:53:17 -0400 X-Google-Sender-Auth: ekpQFSGpiSeM98UJtlnLuIU5Pr4 Message-ID: Subject: Re: Some CouchDB internals questions? From: Zdravko Gligic To: Paul Davis Cc: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org > Have you compacted your db and views? Yes > There's unfortunately no direct way to calculate a upper threshold, it > really depends on your method for inserting as well as how often you > compact. Once both (docs and view) are compacted, is the resulting size at all dependent on how the docs and/or views were created in the first place (one at a time or in bulk or whatever) ? > This is due to the tail append storage which will orphan data > in the file as it writes new records to the various internal data > structures. My 1,500 docs are taking up almost 15 meg (roughly 1/4-1k docs with 2 views + 1 view with doc re-emit) and I believe were around 50meg before compactions. Thanks Paul.