I have a Tilemill project the size of europe. I developed my style-sheet by using a smaller dataset (size auf Austria) and everything was perfect. But now I did apply the same styles to my big europe dataset which is in a PostgreSQL database and it's not rendering anything.
I had a look at what takes so long and it seems as if it is PostgreSQL. I already added all kinds of indexes to my tables, but that doesn't seem to help.
As a starting point I used OSM-Bright and that added a layer called landuse-gen0. It pulls in all the polygons of a certain size.
SELECT way, way_area AS area, COALESCE(landuse, leisure, "natural", highway, amenity, tourism) AS type FROM planet_osm_polygon WHERE way_area > 100000 ORDER BY way_area DESC;
This query result in 3,4M rows. Each has about 10k... which would result in about 34 GB of data just for this one query. But Tilemill is doing a lot of those queries.... And tilemill seems to also be limiting the Bounding-Box AFTER my query... which is pretty inefficient, isn't it?
Any way I can improve my performance? Cause right now nothing is rendered... even if I wait one hour... not even one tile...
Btw. the computer it's running on has 16 cores and 120GB RAM... so hardware shouldn't be the big problem here...
Thanks for any tip!