From user-return-19786-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Mon Feb 13 04:54:58 2012 Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BAE1D9182 for ; Mon, 13 Feb 2012 04:54:58 +0000 (UTC) Received: (qmail 66131 invoked by uid 500); 13 Feb 2012 04:54:57 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 65966 invoked by uid 500); 13 Feb 2012 04:54:55 -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 65958 invoked by uid 99); 13 Feb 2012 04:54:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Feb 2012 04:54:55 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of luismgz@gmail.com designates 209.85.217.180 as permitted sender) Received: from [209.85.217.180] (HELO mail-lpp01m020-f180.google.com) (209.85.217.180) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Feb 2012 04:54:49 +0000 Received: by lbok6 with SMTP id k6so384894lbo.11 for ; Sun, 12 Feb 2012 20:54:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=PNdhsl2UjYp2W4ChnNnbiHMPQ87VsdrOwOmLDBjhGS4=; b=q8t/JU7GRJjZOSNEnO1LVFa1SSn3/RbIQaxi6hbYl5kJooFesW9383qwgF+K/N6lio yvtesZlzu12OodvISaJbbL/uNbOJLigzsRjkS2a+n8is83aT68Jt3gfc8Ee5Bh27zXli Iw5A+OitCIytPqscht7+gf3GGxL0S/kKeoef0= Received: by 10.152.147.137 with SMTP id tk9mr10217173lab.8.1329108868308; Sun, 12 Feb 2012 20:54:28 -0800 (PST) MIME-Version: 1.0 Received: by 10.152.131.36 with HTTP; Sun, 12 Feb 2012 20:54:08 -0800 (PST) In-Reply-To: References: <4F36BE75.2060706@ianhobson.co.uk> From: "Luis M. Gonzalez" Date: Mon, 13 Feb 2012 01:54:08 -0300 Message-ID: Subject: Re: view file growing too large To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=e89a8f2348abf69eec04b8d145d4 --e89a8f2348abf69eec04b8d145d4 Content-Type: text/plain; charset=ISO-8859-1 On Mon, Feb 13, 2012 at 1:51 AM, C J wrote: > Thanks Ian. This is a good place for me to start. I wonder if the block > size is configurable. Do you recall where you read about that? I'd like to > read up on it as well. > > -GN > > On Sat, Feb 11, 2012 at 12:16 PM, Ian Hobson wrote: > > > On 10/02/2012 15:48, C J wrote: > > > >> The view file for my database is growing ten times faster than my > >> database. > >> View compaction recovers much of this used space, but I'd like to > minimize > >> how often I run view compaction. > >> > >> This is just a guess. > > > > IIRC updating the view has to write a new block for each view that has > > new data, even if that is only 1byte. > > > > Blocks are quite large (16K? - I forget). Compaction will recover this > > wasted space. > > > > I would try updating the view rather less often. Say once every 20 > > minutes, not every 10 seconds. Then > > each update has more data and less wasted space. > > > > Regards > > > > Ian > > > > > --e89a8f2348abf69eec04b8d145d4--