[Tile-serving] [openstreetmap/osm2pgsql] Tweaking Postgres for faster tiles generation (#689)

[Koles500]

Hi. I am refering to #676 
So we made it in 15 days :-)  
However... ! Now generating tiles with generate_tiles.py script (from here: http://svn.openstreetmap.org/applications/rendering/mapnik) for whole Europe is awfully slow, it generate ~ 135 tiles in ~ 10 minutes, I am running it for zoom level from 3 to 16 for whole Europe 

```
    minZoom = 3
    maxZoom = 16
    
    bbox = (-25.7251167, 34.3190864, 34.9770923, 72.4137726)
    render_tiles(bbox, mapfile, tile_dir, minZoom, maxZoom, "Europe")
```

How can we optimize Postgres and that script so it will run faster (I know SSD would help but we dont have it yet ^^) ? Thanks.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/689
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170208/fa9573bd/attachment.html>