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

[ImreSamu]

> How can we optimize Postgres ...

see 
* http://www.paulnorman.ca/blog/2016/06/improving-speed-with-reclustering/
* http://www.paulnorman.ca/blog/2016/08/identifying-slow-rendering-queries/
* http://www.paulnorman.ca/blog/2016/08/sampling-slow-postgres-queries/
* http://www.paulnorman.ca/blog/2015/06/real-performance-numbers-for-a-style/
* http://www.paulnorman.ca/blog/archives/
* ... 

and
* "osm2pgsql:mapnik — Optimizing the Rendering Toolchain - Paul Norman"  https://www.youtube.com/watch?v=Lxloo42gl8A  ( video )
* http://www.paulnorman.ca/files/osm2pgsql-performance.pdf

and:
*  https://wiki.postgresql.org/wiki/Performance_Optimization



-- 
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#issuecomment-278543211
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170208/1f018bc8/attachment.html>