couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From C J <guerillan...@gmail.com>
Subject Re: view file growing too large
Date Mon, 13 Feb 2012 04:51:14 GMT
Thanks Ian. This is a good place for me to start. I wonder if the block
size is configurable. Do you recall where you read about that? I'd like to
read up on it as well.

-GN

On Sat, Feb 11, 2012 at 12:16 PM, Ian Hobson <ian@ianhobson.co.uk> wrote:

> On 10/02/2012 15:48, C J wrote:
>
>> The view file for my database is growing ten times faster than my
>> database.
>> View compaction recovers much of this used space, but I'd like to minimize
>> how often I run view compaction.
>>
>>  This is just a guess.
>
> IIRC updating the view has to write a new block for  each view that has
> new data, even if that is only 1byte.
>
> Blocks are quite large (16K? - I forget).  Compaction will recover this
> wasted space.
>
> I would try updating the view rather less often. Say once every 20
> minutes, not every 10 seconds. Then
> each update has more data and less wasted space.
>
> Regards
>
> Ian
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message