Re: [OSM-talk] Slow TileMill rendering - Postgres using 1 core?

2013-08-25 Thread Christian Quest
As far as I know, Tilemill is using mapnik which is querying postgres. Plain vanilla Mapnik is not doing more than one postgres query at a time (not multithreading queries). A patch made by mappy allows mapnik to multithread its pg queries. Are you using the exact same version of Mapnik as before

Re: [OSM-talk] Slow TileMill rendering - Postgres using 1 core?

2013-08-25 Thread Steve Bennett
Hi Christian, Thanks for the reply. After further investigation the actual problem was a missing index on planet_osm_polygon. (I'm really not sure why.) Steve On Sun, Aug 25, 2013 at 9:00 PM, Christian Quest cqu...@openstreetmap.frwrote: As far as I know, Tilemill is using mapnik which is

[OSM-talk] Slow TileMill rendering - Postgres using 1 core?

2013-08-24 Thread Steve Bennett
Hi all, I'm running TileMill on an 8 core Ubuntu VM with 32GB of memory, on an OpenStack cloud. Recently, my VM was destroyed, and I rebuilt it (identically, I thought) on slightly different hardware (same cloud, but different physical infrastructure). The new build is much slower at rendering -