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 3F167104AA for ; Sat, 15 Mar 2014 17:57:38 +0000 (UTC) Received: (qmail 25828 invoked by uid 500); 15 Mar 2014 17:57:36 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 25783 invoked by uid 500); 15 Mar 2014 17:57:36 -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 25696 invoked by uid 99); 15 Mar 2014 17:57:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 15 Mar 2014 17:57:35 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jens@couchbase.com designates 199.193.200.199 as permitted sender) Received: from [199.193.200.199] (HELO hub029-VA-8.exch029.serverdata.net) (199.193.200.199) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 15 Mar 2014 17:57:28 +0000 Received: from [10.0.1.9] (173.228.7.198) by east.exch029.serverdata.net (10.216.105.237) with Microsoft SMTP Server (TLS) id 14.3.174.1; Sat, 15 Mar 2014 10:57:05 -0700 Content-Type: text/plain; charset="windows-1252" MIME-Version: 1.0 (Mac OS X Mail 7.3 \(1875\)) Subject: Re: Reseting DB Sequence Number From: Jens Alfke In-Reply-To: Date: Sat, 15 Mar 2014 10:57:01 -0700 Content-Transfer-Encoding: quoted-printable Message-ID: References: To: X-Mailer: Apple Mail (2.1875) X-Virus-Checked: Checked by ClamAV on apache.org On Mar 15, 2014, at 5:28 AM, Behrad wrote: > I see my view generation gets over 50,000,000 changes but I have only > 1,000,000 docs (most changes are archiving doc deletions) Resetting the sequence number wouldn=92t do anything about that. What = you want to do, I think, is purge all the deleted docs. You can create a = view that finds all deleted docs, then query the view and pass all the = doc IDs to _purge. =97Jens=