Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of chrisstocktonaz@gmail.com
 designates 209.85.210.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CABvT1DGbK--5DH+45iTum9rbL1fJDYfnZNgVFa5fZhrMX94eRw@mail.gmail.com>
References: 
 <CALKFbxuJePZPpOeRtPnvQAZBOroerubEBds8Bwz57HwimTk3dg@mail.gmail.com>
	<CABvT1DHtX4qm-1vODm2OMHEKxA_6kKT-DiL9OTe2vyoc8FGVyA@mail.gmail.com>
	<CALKFbxtaKitPLunhdh_R2Bvrbejqv7+==Xy8BkvdUVhV3iQv9w@mail.gmail.com>
	<CABvT1DGbK--5DH+45iTum9rbL1fJDYfnZNgVFa5fZhrMX94eRw@mail.gmail.com>
Date: Thu, 22 Dec 2011 14:44:41 -0700
Message-ID: 
 <CALKFbxuWwtcHY+DkvssQsGuR1UfS0s7CzPq85fb9rux9DGeOBg@mail.gmail.com>
Subject: Re: Database size seems off even after compaction runs.
From: Chris Stockton <chrisstocktonaz@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hello,

On Thu, Dec 22, 2011 at 2:36 PM, Robert Newson <rnewson@apache.org> wrote:
> Deleted docs are preserved forever (necessary for eventual consistency).
>
> If you know the doc id of a deleted doc, try GET
> host:port/dbname/docname?open_revs=all
>
> You should be able to find your deleted docs via the _changes feed, e.g.;
>
> ~ $ curl localhost:5984/foo/_changes
> {"results":[
> {"seq":2,"id":"bar","changes":[{"rev":"2-91257658886b5692a98d053bb9990b47"}],"deleted":true}
> ],
> "last_seq":2}
>
> B.
>

Robert, I thought I was becoming a couchdb expert, totally tossed out
that theory for me :p

Okay, so this catches me a bit off guard, always thought compaction
cleaned those up. Is there a good way to bulk remove all deleted docs?
Or will I need to make DELETE calls on each individual document?

Thanks a ton, I appreciate it!

-Chris