Åre you sure about the length in the fields? If you are using UTF-8 one character can be multiple bytes.
Mikael Söderström Skickat från min Windows Phone ________________________________ From: Sharath<mailto:[email protected]> Sent: 2015-01-25 07:53 To: [email protected]<mailto:[email protected]> Subject: Re: couchdb database size yes the databases were recently compacted - both the databases run as insert only (no deletion for either). database2 completed compaction about 4 hours ago and I've triggered compaction again (so what you see below for database2 could be misleading) database1: { "db_name":"database1", "doc_count":13337224, "doc_del_count":0, "update_seq":13337224, "purge_seq":0, "compact_running":false, "disk_size":8574615674, "data_size":6896805847, "instance_start_time":"1422157234994080", "disk_format_version":6, "committed_update_seq":13337224 } database2: { "db_name":"database2", "doc_count":12982621, "doc_del_count":0, "update_seq":12982621, "purge_seq":0, "compact_running":true, "disk_size":31587352698, "data_size":8026729752, "instance_start_time":"1422157235289671", "disk_format_version":6, "committed_update_seq":12982621 } -Sharath On Sun, Jan 25, 2015 at 5:40 PM, Alexander Shorin <[email protected]> wrote: > 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 > >> >
