{"action":"created","issue":{"url":"https://api.github.com/repos/mapbox/osm-bright/issues/95","labels_url":"https://api.github.com/repos/mapbox/osm-bright/issues/95/labels{/name}","comments_url":"https://api.github.com/repos/mapbox/osm-bright/issues/95/comments","events_url":"https://api.github.com/repos/mapbox/osm-bright/issues/95/events","html_url":"https://github.com/mapbox/osm-bright/issues/95","id":55294763,"number":95,"title":"OSMBright incredibly slow for osm2pgsql output","user":{"login":"bkj","id":6086781,"avatar_url":"https://avatars.githubusercontent.com/u/6086781?v=3","gravatar_id":"","url":"https://api.github.com/users/bkj","html_url":"https://github.com/bkj","followers_url":"https://api.github.com/users/bkj/followers","following_url":"https://api.github.com/users/bkj/following{/other_user}","gists_url":"https://api.github.com/users/bkj/gists{/gist_id}","starred_url":"https://api.github.com/users/bkj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bkj/subscriptions","organizations_url":"https://api.github.com/users/bkj/orgs","repos_url":"https://api.github.com/users/bkj/repos","events_url":"https://api.github.com/users/bkj/events{/privacy}","received_events_url":"https://api.github.com/users/bkj/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-01-23T15:33:23Z","updated_at":"2015-02-09T04:51:33Z","closed_at":null,"body":"I used osm2pgsql to load the OpenStreetMap planet.osm.pbf file into Postgres (27 GB in .osm.pbf format, ~350GB in the database).  Now when I open the OSMBright project in Tilemill, all of machine's cores light up but no tiles show up.  After waiting 5+ minutes layer 0 tiles show up and then a smattering of layer 1 and 2 tiles, but then it seems to stall out.  Any ideas on what the bottleneck would be?  \r\n\r\nIs it possible that some index didn't get built in the database so it's doing some kind of much slower search?  Or maybe I need to allocate more memory to Tilemill or Postgres?\r\n\r\nI followed the instructions here\r\nhttps://www.mapbox.com/tilemill/docs/guides/osm-bright-mac-quickstart/\r\nfor setup.\r\n\r\nThanks!\r\nBen\r\n\r\nSome specs:\r\nMacBook Pro, OS X 10.9.5, 16GB RAM, 8 CPUs, 100+ GB free disk space"},"comment":{"url":"https://api.github.com/repos/mapbox/osm-bright/issues/comments/73457334","html_url":"https://github.com/mapbox/osm-bright/issues/95#issuecomment-73457334","issue_url":"https://api.github.com/repos/mapbox/osm-bright/issues/95","id":73457334,"user":{"login":"bkj","id":6086781,"avatar_url":"https://avatars.githubusercontent.com/u/6086781?v=3","gravatar_id":"","url":"https://api.github.com/users/bkj","html_url":"https://github.com/bkj","followers_url":"https://api.github.com/users/bkj/followers","following_url":"https://api.github.com/users/bkj/following{/other_user}","gists_url":"https://api.github.com/users/bkj/gists{/gist_id}","starred_url":"https://api.github.com/users/bkj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bkj/subscriptions","organizations_url":"https://api.github.com/users/bkj/orgs","repos_url":"https://api.github.com/users/bkj/repos","events_url":"https://api.github.com/users/bkj/events{/privacy}","received_events_url":"https://api.github.com/users/bkj/received_events","type":"User","site_admin":false},"created_at":"2015-02-09T04:51:33Z","updated_at":"2015-02-09T04:51:33Z","body":"@springmeyer thanks for the answer.  I downloaded Mapbox Studio and it seems like I'm running into a similar problem.  I can try to add a PostGIS layer pointing at the local server, using \"planet_osm_polygons\" in the large box in the \"SQL\" tab.  The map will start to render (maybe show one tile), but then it starts using lots of resources and eventually freezes.  Can you think of anywhere else in the process where I might be going wrong?  Or think of a test I could use to try to isolate the problem?\r\n\r\nThanks"}}