Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 73890 invoked from network); 14 Jan 2009 16:59:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Jan 2009 16:59:30 -0000 Received: (qmail 95686 invoked by uid 500); 14 Jan 2009 16:59:27 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 95656 invoked by uid 500); 14 Jan 2009 16:59:27 -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 95645 invoked by uid 99); 14 Jan 2009 16:59:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Jan 2009 08:59:27 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of paul.p.carey@gmail.com designates 72.14.220.159 as permitted sender) Received: from [72.14.220.159] (HELO fg-out-1718.google.com) (72.14.220.159) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Jan 2009 16:59:21 +0000 Received: by fg-out-1718.google.com with SMTP id 13so344597fge.3 for ; Wed, 14 Jan 2009 08:58:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=6gORz7qqXk7SUe/+GmAWX1ofPIbqhgvHsUb3I1kL6uI=; b=nveixFLSvDHf6jNz6sawJ5dw6HLA45N1vSk7nb/RUTIBDSO14AIxy7MVrBT9sylZba yd/9O2zkMzkPxUMDK6hw9HZJmz1+4iCCfLMpgSi09bYZwwGAp5bQV0lKdawDumUmPayk Cot6etZZ18mu+KZyUzkrpcd0jgSP1nNU5NtZA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=ndBuRpIOTZaiLhxsJqJk9CAXlXsZtvZOjZCAHyHd5MXjgnn8H/htpxXM62JVI6PHKa Yp9WYXBMKrN8idj9j+IpWD+7Dx+FGJrID3r0EVZY+NjKpLgw2N8CstqLiZhNmXkWwXZ8 E1b6LkMHFEsdO6zSVVoDb+ZW3mO0ecyRqPa3E= Received: by 10.86.84.18 with SMTP id h18mr812858fgb.22.1231952339594; Wed, 14 Jan 2009 08:58:59 -0800 (PST) Received: by 10.86.36.9 with HTTP; Wed, 14 Jan 2009 08:58:59 -0800 (PST) Message-ID: <13ae4dd50901140858x5e5c450uf14b67698756af3e@mail.gmail.com> Date: Wed, 14 Jan 2009 16:58:59 +0000 From: "Paul Carey" To: user@couchdb.apache.org Subject: Re: Progress of view generation In-Reply-To: <1231947933.543.15.camel@chris-laptop> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1231947933.543.15.camel@chris-laptop> X-Virus-Checked: Checked by ClamAV on apache.org Hi Chris > I have a database containing more than 11-million documents (87 GB). > > As can be expected, the view generation is taking quite a long time. > The problem is, though, that I have no idea how long it could take; I'm > not even sure whether it could be a matter of hours, days, weeks, ... At a guess, hours, probably quite a few. > So, I guess I am wondering if there's any way to gauge the progress of > the generation of these views -- or at least to be sure the views are > actually being generated and I'm not just watching the Futon > spinny-thing go on endlessly. There is indeed. Take a look at /usr/local/var/lib/couchdb/.my_design_doc.couch/Myview.view You should be able to see it growing while view generation is taking place. Given that you're emitting the doc as a value, and assuming your map function as is you stated e.g. no filtering is being performed, you can expect the size of the view file to be in the same ballpark as the size of you database. > That is, once the view has been generated once, can I be confident > that further generations (assuming I've only added a small number of > documents since the last generation) will be reasonably quick? Yes. Paul