Not sure how many docs you have, but can you filter replicate the good docs into a new db?
Jim Klo Senior Software Engineer Center for Software Engineering SRI International On May 18, 2012, at 10:39 AM, Tim Tisdall wrote: > After further reading it seems like I could use _purge ... However, I > still need to query the DB to fetch all the revisions. > > On Fri, May 18, 2012 at 12:12 PM, Tim Tisdall <tisd...@gmail.com> wrote: > >> I accidentally created several million documents in my DB which I'd like >> to undo. ^_^ I know I can query each document to get the revision and >> then issue a DELETE, but that seems like a lot of additional work. Also, >> the wiki says "Deleted documents remain in the database forever, even after >> compaction, to allow eventual consistency when replicating." and that's a >> lot of dead space. Is there a way that I can purge all of those documents >> given that I have the _ids that they were saved under? I essentially would >> like to return the DB to a state before I inserted all of those documents. >> >> I'm also going to be inserting updated documents to the DB with those same >> _ids, so another alternative is to post updates to each (but that would >> also require getting the revision ids) and then clearing out old revisions. >> However, this would require fetching several million revision ids and then >> figuring out how to force the DB to clear out all old revisions. >> >> -Tim >>
smime.p7s
Description: S/MIME cryptographic signature