We run compaction nightly. We also don’t need to keep revision history, so if you need it…obviously this won’t work for you.
> On Feb 2, 2016, at 3:17 PM, Anik Das <[email protected]> wrote: > > Is it a convention to run compact query on an frequent interval? > > > > And I would also love to know the reason behind it. (My initial thought is > that whenever a insertion happens it creates a new revision of the view and > that could be one reason) > > > > Thanks in advance. :) > > > >> On Feb 2 2016, at 6:12 pm, Александр Опак <[email protected]> > wrote: > >> > >> it's normal :) > >> > >> 2016-02-02 23:08 GMT+02:00 Anik Das <[email protected]>: > > Hello All, > > > > We were developing an application where we had to insert approximately > 600,000 > > documents into a database. The database had only one view (value emitted > as > > null). > > > > > > > > It was not a batch insertion. After the insertion the database took up > 3.5GB > > to our wonder. I googled around and did a compact query. After the > compact > > query the size reduced to 350MB. > > > > > > > > I am new to couchdb and I'm unable to figure out what exactly is > > happening/happened. > > > > > > > > Anik Das > > > >> > >> \-- > github: > https://github.com/OpakAlex >
