Re: Storage Issues on 600,000 document insertion

[Anik Das]

Thank you Dan will try this method.

> On Feb 2 2016, at 6:22 pm, Dan Santner <dansant...@me.com> wrote:  

>

> 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 <maila...@gmail.com> 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, Александр Опак
<opak.alexa...@gmail.com>  
> wrote:  
>  
>>  
>  
>> it's normal :)  
>  
>>  
>  
>> 2016-02-02 23:08 GMT+02:00 Anik Das
<maila...@gmail.com>:  
> > 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  
>