couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Newson <rnew...@apache.org>
Subject Re: Database size seems off even after compaction runs.
Date Thu, 22 Dec 2011 21:20:37 GMT
Deleted docs take space. If you used the DELETE http method, then it's
minimal, but if you just added _deleted:true to your document and
saved, then it contains all the data of the previous revision,
including all attachments.

B

On 22 December 2011 21:01, Chris Stockton <chrisstocktonaz@gmail.com> wrote:
> We have a customer using 11MB of disk space, not much but it so
> happens the user is using more like 100KB of data. One thing we have
> noticed is that the users doc_del_count is very high, indicating he
> likely had 11mb of data but later deleted it.
>
> {"db_name":"...snip...","doc_count":49,"doc_del_count":42981,"update_seq":86097,"purge_seq":0,"compact_running":false,"disk_size":11427940,"instance_start_time":"1324102884349705","disk_format_version":5,"committed_update_seq":86097}
>
> After compaction the size does not change, the physical file on the
> file system is verified 11MB.
>
> Viewing _all_docs shows a page and a half of data, viewing futon shows
> the user really is using around 100kb max.
>
> Any guesses here?
>
> -Chris

Mime
View raw message