[
https://issues.apache.org/jira/browse/COUCHDB-1243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Henrik Hofmeister updated COUCHDB-1243:
---------------------------------------
Description:
After running db and view compaction on a 70K doc db with 6+ mio. changes - it
takes up 0.8 GB. If copying the same documents to a new db (get and bulk
insert) - the same date with 70K changes (only the inserts) takes up 40 mb.
That is a huge difference. Has been verified on 2 db's that the difference is
more than 65 times the size of data.
A "Compact and copy" feature that copies only documents, and resets the changes
for at db would be very nice to try and limit the disk usage a little bit. (Our
current test environment takes up nearly 100 GB... )
I've attached the dump load php script for your convenience.
was:
After running db and view compaction on a 7K doc db with 6+ mio. changes - it
takes up 0.8 GB. If copying the same documents to a new db (get and bulk
insert) - the same date with 7K changes takes up 40 mb. That is a huge
difference. Has been verified on 2 db's that the difference is more than 65
times the size of data.
A "Compact and copy" feature that copies only documents, and resets the changes
for at db would be very nice to try and limit the disk usage a little bit. (Our
current test environment takes up nearly 100 GB... )
I've attached the dump load php script for your convenience.
> Compact and copy feature that resets changes
> --------------------------------------------
>
> Key: COUCHDB-1243
> URL: https://issues.apache.org/jira/browse/COUCHDB-1243
> Project: CouchDB
> Issue Type: New Feature
> Components: Database Core
> Affects Versions: 1.0.1, 1.1
> Environment: Ubuntu, but not important
> Reporter: Henrik Hofmeister
> Labels: cleanup, compaction
> Attachments: dump_load.php
>
>
> After running db and view compaction on a 70K doc db with 6+ mio. changes -
> it takes up 0.8 GB. If copying the same documents to a new db (get and bulk
> insert) - the same date with 70K changes (only the inserts) takes up 40 mb.
> That is a huge difference. Has been verified on 2 db's that the difference is
> more than 65 times the size of data.
> A "Compact and copy" feature that copies only documents, and resets the
> changes for at db would be very nice to try and limit the disk usage a little
> bit. (Our current test environment takes up nearly 100 GB... )
> I've attached the dump load php script for your convenience.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
