incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel de Oliveira Barbosa <manobi.olive...@gmail.com>
Subject Re: Bulk deletes and disk size
Date Sat, 08 Mar 2014 02:27:48 GMT
Looking in the Couchdb docs there are just examples using POST for bulk
updates, so real bulk deletes are really a possible thing ?
http://docs.couchdb.org/en/latest/api/database/bulk-api.html?highlight=bulk#post--db-_bulk_docs


2014-03-07 23:19 GMT-03:00 Gabriel de Oliveira Barbosa <
manobi.oliveira@gmail.com>:

> I though that compactation process would remove the body from the document
> marked with "_deleted".
> These deleted docs (marked with _delete) do not have previous revisions or
> attachments, so the disk size is the result of millions of documents with
> their body forgotten in the database?
>
> So to be effective my "bulk delete" have to be a PUT request? because I'm
> already doing  {"_id":"foo", "_rev":"bar", "_deleted":true} but using
> node.js cradle db.save([doc1,doc2,doc3]) and I'm not sure if it uses PUT or
> POST behind it.
>
>
> 2014-03-07 13:05 GMT-03:00 Robert Samuel Newson <rnewson@apache.org>:
>
> The user says he just added _deleted:true to his documents, which marks
>> the document as deleted but will forever preserve all values in the
>> document, including attachments. You're right that compaction will remove
>> bodies and attachments from non-leaf revisions, however.
>>
>> B.
>>
>> On 7 Mar 2014, at 15:56, Jens Alfke <jens@couchbase.com> wrote:
>>
>> >
>> > On Mar 7, 2014, at 1:47 AM, Robert Samuel Newson <rnewson@apache.org>
>> wrote:
>> >
>> >> Adding _deleted:true marks the document as deleted only, it does not
>> remove the body or the attachments. This is why your disk usage has not
>> reduced; you haven't reduced the size of your documents.
>> >
>> > Gabriel did say the database is "compacted periodically". So that
>> should be getting rid of the old bodies and attachments.
>> >
>> > --Jens
>>
>>
>

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