Hi Sharath, What is your CouchDB version? Could you provide data_size and disk_size values from database info for both? curl http://localhost:5984/db1 curl http://localhost:5984/db2 -- ,,,^..^,,,
On Sun, Jan 25, 2015 at 7:11 AM, Sharath <[email protected]> wrote: > Hi All, > > recently moved to couchdb and find my databases taking a lot of diskspace > > I have two database both with json documents (no attachments) - however the > sizes vary by a lot > > database1 size 8.0GB number of documents: 13337224 > database2 size 29.4 GB number of documents: 12981148 > > both the databases have been compacted > > each document in database1 is 487 bytes long (including _id and _rev) > each document in database2 is 564 bytes long (including _id and _rev) > > database1 should be ~6.1GB (only data without compression) [487 * 13337224 > / 1024 /1024] > database2 should be ~6.9GB (only data without compression) [564 * 12981148 > / 1024 /1024] > > I'm curious why the database file takes 29 GB. > > unfortunately I cannot post the document as this is prod data. > > CouchDb is running on my mac 10.10.1 with default configuration. > > database1 was populated by a bulk upload from a mysql extract and database > 2 was populated by individual document inserts (put) database compaction > was let to complete (took ~30hr on database 2) > > is there a command that compacts superfluous data? or am i missing anything? > > > thanks! > > -Sharath
