I've successfully imported the whole planet but now I'm still having the slow rendering issue.
I'm just trying to load one tile after the server just started, and I'm seeing the requests Frederik told me before that it was normal at the renderd start:
SELECT ST_XMin(ext),ST_YMin(ext),ST_XMax(ext),ST_YMax(ext) FROM (SELECT ST_Extent(way) as ext from planet_osm_polygon) as tmp
This one * 5 when I'm looking in `pg_stat_activity`. And it seems to never go further, I've checked 20 minutes after and there was the sames queries (and only these), but with a more recent query_start and a different pid, to it's like the queries ended, and were restarted... But I really don't understand why, or even what they're supposed to do.
In the renderd logs, I see that when the rendering start:
renderd[21]: DEBUG: Got incoming connection, fd 6, number 1
renderd[21]: DEBUG: Got incoming request with protocol version 2
renderd[21]: DEBUG: Got command RenderPrio fd(6) xml(fr), z(10), x(530), y(367), mime(image/png), options()
renderd[21]: DEBUG: START TILE fr 10 528-535 360-367, new metatile
renderd[21]: Rendering projected coordinates 10 528 360 -> 626172.135713|5635549.221413 939258.203569|5948635.289269 to a 8 x 8 tile
renderd[21]: DEBUG: Connection 0, fd 6 closed, now 0 left
But after that, nothing.
Nothing in the postgresql logs either.
Does somebody have an idea of what could cause that?
Thanks!
**EDIT:** After almost an hour (yeaaah) the tile was done:
renderd[21]: DEBUG: DONE TILE fr 10 528-535 360-367 in 3193.842 seconds
debug: Creating and writing a metatile to /var/lib/mod_tile/fr/10/0/0/33/22/8.meta
But then I started another (random) tile at zoom 16, which should be fast... It was a few minutes ago, I'm still waiting...waiting... And I'm still seeing the same requests in `pg_stat_activity`.
