CouchDB Weekly News, September 25, 2014

Major Discussions

Is there a general rule to estimate the maximum disk space for a CouchDB database? (see thread)

Question: A user asked if there’s a way to roughly estimate the maximum disk space needed for a CouchDB database.


  • That’s extremely hard to tell. If users update each document individually, they need more disk space than if they use bulk updates on multiple documents at once (until compaction runs).
  • Users also need to take account for the views and their compaction (there was an example by another user of a view of 6,6GB before and 187MB size after compaction).
  • It may also depend on how good the data compresses.
  • Example: a CouchDB with 1000 documents of 1kb size added in the beginning of each day, that updates every hour. So for single day there’d be 1MB of initial data plus 23MB from revisions. 24MB per day results in 720 MB per average month and 8.7 GB per year. However, for each day 23MB of overhead data for previous revisions are accumulated, which could be cleaned up during compaction. So if users run compaction at the end of day, 1MB per day will be the grow rate.
  • It’s lso worth to take into account that while CouchDB cleans up old revisions on compaction, it doesn’t removes their ids from the document to preserve its history: this will give users also small size overhead on top, but no significant one.
  • Additionally it’s worth to know that CouchDB grows db by 4KiB chunks, no matter if the stored document is even smaller then, and that the file system may preallocate more space for a file than it actually contains.

Setting up CouchDB 2.0 (see thread)

Since the community is getting close to feature completeness, the topic of setting up CouchDB 2.0 solo and as a cluster was brought up and is now being discussed. Starting what is being envisioned (see initial email), this needs to be squared against the current implementation, required engineering and security considerations. You’ll find the complete discussion here.

Physical database movement without shutting down CouchDB (see thread)

Question: Is there any way to move database files physically without shutting down the whole CouchDB engine?

Answer: One approach could be to use mdadm with the “build” option to mirror the current device to the new device, remove the old device from the mirror and then perform a resize operation on the filesystem of the new device to gain access to the extra storage. All those steps may be doable online.

Learning a lot about and getting into CouchDB (see thread)

Question: Which ways are there for getting into CouchDB and learning more about it?

Answer: These are some of the main resources for learning more about CouchDB:

Releases in the CouchDB Universe

Opinions and other News in the CouchDB Universe

Use Cases, Questions and Answers

No public answer yet:

For more new questions and answers about CouchDB, see these search results.

Get involved!

If you want to get into working on CouchDB:

  • We have an infinite number of open contributor positions on CouchDB. Submit a pull request and join the project!
  • Do you want to help moving the CouchDB docs translation forward? We’d love to have you in our L10n team! See our current status and languages we’d like to provide CouchDB docs in on this page. If you’d like to help, don’t hesitate to contact the L10n mailing list on or ping Andy Wenk (awenkhh on IRC).

We’d be happy to have you!


Time to relax!

  • “We all have moments that change the way we think, the way that we look at the world, the things we want to do with our lives. On July 20, 1969 a whole generation of Americans had one of those transforming experiences: Two men landed on the Moon and nothing was ever the same again. Why did we go to the Moon? How did we get there? What was it like to witness it all? And what does any of this have to do with writing software 40 years later?”Russ Olsen: Going to the Moon (talk video)
  • “We as members of Open Source Communities have to implement a culture where mental health issues are not stigmatized, … a culture in which people are heard and they know that there are people who care for them.” – This is bigger than us: Building a future for Open Source (presentation slides with notes)

… and also in the news