On Thu, Sep 6, 2012 at 4:18 PM, Tim Tisdall <[email protected]> wrote: > I had a database of about 10.8gb with almost 15 million records which > was fully compacted. I had to back it up by dumping all the JSON and > then restoring it by inserting it back in. After it was done and I > compacted it the database was now only 8.8gb! I shed 2gb because of > dropping the revision stubs still in the database. This is likely > because each record had about 6 revisions (so around 90 million > stubs). All of this is understandable, but 2gb isn't really > negligible when running on a virtualized instance of 35gb. The > problem, though, is the method I used to dump to JSON and place it > back into couchdb took almost 12hrs! > > Is there a way to drop all of the revision stubs and reset the > document's revision tags back to "1-" values? I know this would > completely break any kind of replication, but in this instance I am > not doing any.
It would break more than the replication. Compacting your database is the solution. - benoît
