Hm...are you sure that database was recently compacted? How many deleted documents in these databases? -- ,,,^..^,,,
On Sun, Jan 25, 2015 at 9:27 AM, Sharath <[email protected]> wrote: > 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 >>
