Hi Alexander, CouchDB version: 1.61
database1: "disk_size":8574615674,"data_size":6896805847 database2: "disk_size":31587352698,"data_size":8026729752 -Sharath On Sun, Jan 25, 2015 at 4:55 PM, Alexander Shorin <[email protected]> wrote: > 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 >
