{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/2425","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/2425/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/2425/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/2425/events","html_url":"https://github.com/influxdb/influxdb/issues/2425","id":70820475,"number":2425,"title":"Tags incur too much memory and degrade performance ","user":{"login":"marcosnils","id":1578458,"avatar_url":"https://avatars.githubusercontent.com/u/1578458?v=3","gravatar_id":"","url":"https://api.github.com/users/marcosnils","html_url":"https://github.com/marcosnils","followers_url":"https://api.github.com/users/marcosnils/followers","following_url":"https://api.github.com/users/marcosnils/following{/other_user}","gists_url":"https://api.github.com/users/marcosnils/gists{/gist_id}","starred_url":"https://api.github.com/users/marcosnils/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marcosnils/subscriptions","organizations_url":"https://api.github.com/users/marcosnils/orgs","repos_url":"https://api.github.com/users/marcosnils/repos","events_url":"https://api.github.com/users/marcosnils/events{/privacy}","received_events_url":"https://api.github.com/users/marcosnils/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-04-24T23:24:47Z","updated_at":"2015-04-27T17:44:11Z","closed_at":"2015-04-24T23:39:35Z","body":"I'm writing 1000000 points in batches of 1000 to a database in influx and I've decided to add a tag which is a string of 12bytes. After adding the tag i've noticed that the insertion rate really decreased (almost 2x) and that the memory is not efficiently handled. \r\n\r\nAfter adding one tag with values of 12bytes the memory of the influx process went up to x1000 times more than without it. Attached you'll find the timing results of the 1M points insertion as well as `go tool pprof heap` results. \r\n\r\nWithout using tags:\r\n\r\nreal    3m15.122s\r\nuser    1m20.434s\r\nsys     0m1.486s\r\n\r\n![image](https://cloud.githubusercontent.com/assets/1578458/7329744/3be4d0e8-eab9-11e4-9e69-ef9dd54dd055.png)\r\n\r\nhttps://github.com/marcosnils/influxdb/blob/perf/notags.svg (download and open in browser)\r\n\r\nWith tags: \r\n\r\n![image](https://cloud.githubusercontent.com/assets/1578458/7329953/7cb936c4-eabc-11e4-99d0-dc76505fad54.png)\r\n\r\nreal    5m34.459s\r\nuser    1m25.126s\r\nsys     0m1.457s\r\n\r\nhttps://github.com/marcosnils/influxdb/blob/perf/tags.svg (download and open in browser)\r\n\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/96753844","html_url":"https://github.com/influxdb/influxdb/issues/2425#issuecomment-96753844","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/2425","id":96753844,"user":{"login":"otoolep","id":536312,"avatar_url":"https://avatars.githubusercontent.com/u/536312?v=3","gravatar_id":"","url":"https://api.github.com/users/otoolep","html_url":"https://github.com/otoolep","followers_url":"https://api.github.com/users/otoolep/followers","following_url":"https://api.github.com/users/otoolep/following{/other_user}","gists_url":"https://api.github.com/users/otoolep/gists{/gist_id}","starred_url":"https://api.github.com/users/otoolep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/otoolep/subscriptions","organizations_url":"https://api.github.com/users/otoolep/orgs","repos_url":"https://api.github.com/users/otoolep/repos","events_url":"https://api.github.com/users/otoolep/events{/privacy}","received_events_url":"https://api.github.com/users/otoolep/received_events","type":"User","site_admin":false},"created_at":"2015-04-27T17:44:11Z","updated_at":"2015-04-27T17:44:11Z","body":"The plan is to support appending in the 0.9 release."}}