{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/3602","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/3602/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/3602/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/3602/events","html_url":"https://github.com/CartoDB/cartodb/issues/3602","id":75312737,"number":3602,"title":"Importer creating spare index on cartodb_id","user":{"login":"pramsey","id":113883,"avatar_url":"https://avatars.githubusercontent.com/u/113883?v=3","gravatar_id":"","url":"https://api.github.com/users/pramsey","html_url":"https://github.com/pramsey","followers_url":"https://api.github.com/users/pramsey/followers","following_url":"https://api.github.com/users/pramsey/following{/other_user}","gists_url":"https://api.github.com/users/pramsey/gists{/gist_id}","starred_url":"https://api.github.com/users/pramsey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pramsey/subscriptions","organizations_url":"https://api.github.com/users/pramsey/orgs","repos_url":"https://api.github.com/users/pramsey/repos","events_url":"https://api.github.com/users/pramsey/events{/privacy}","received_events_url":"https://api.github.com/users/pramsey/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/CartoDB/cartodb/labels/EASY","name":"EASY","color":"fbca04"},{"url":"https://api.github.com/repos/CartoDB/cartodb/labels/importer","name":"importer","color":"eb6420"}],"state":"closed","locked":false,"assignee":{"login":"rafatower","id":1914276,"avatar_url":"https://avatars.githubusercontent.com/u/1914276?v=3","gravatar_id":"","url":"https://api.github.com/users/rafatower","html_url":"https://github.com/rafatower","followers_url":"https://api.github.com/users/rafatower/followers","following_url":"https://api.github.com/users/rafatower/following{/other_user}","gists_url":"https://api.github.com/users/rafatower/gists{/gist_id}","starred_url":"https://api.github.com/users/rafatower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rafatower/subscriptions","organizations_url":"https://api.github.com/users/rafatower/orgs","repos_url":"https://api.github.com/users/rafatower/repos","events_url":"https://api.github.com/users/rafatower/events{/privacy}","received_events_url":"https://api.github.com/users/rafatower/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-05-11T18:23:07Z","updated_at":"2015-11-26T17:44:01Z","closed_at":"2015-11-26T17:44:01Z","body":"@chriswhong reported and I verified on a randomly selected table of my own, two indices! \r\nIn my case, on `nyc_homicides` I get `nyc_homicides_cartodb_id_key` and also `nyc_homicides_pkey`.\r\n\r\nThe last one is probably the one that is implicitly created when the table is given a UNIQUE PRIMARY KEY constraint. The first one is probably created by hand. Since they are on the same thing, it's double the storage for no advantage at all."},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/159967138","html_url":"https://github.com/CartoDB/cartodb/issues/3602#issuecomment-159967138","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/3602","id":159967138,"user":{"login":"rafatower","id":1914276,"avatar_url":"https://avatars.githubusercontent.com/u/1914276?v=3","gravatar_id":"","url":"https://api.github.com/users/rafatower","html_url":"https://github.com/rafatower","followers_url":"https://api.github.com/users/rafatower/followers","following_url":"https://api.github.com/users/rafatower/following{/other_user}","gists_url":"https://api.github.com/users/rafatower/gists{/gist_id}","starred_url":"https://api.github.com/users/rafatower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rafatower/subscriptions","organizations_url":"https://api.github.com/users/rafatower/orgs","repos_url":"https://api.github.com/users/rafatower/repos","events_url":"https://api.github.com/users/rafatower/events{/privacy}","received_events_url":"https://api.github.com/users/rafatower/received_events","type":"User","site_admin":false},"created_at":"2015-11-26T17:44:01Z","updated_at":"2015-11-26T17:44:01Z","body":"Solved in new cartodbfy'ation indeed. Deploying latest fixes to all users' DB's"}}