[OSM-dev] mod_tile performance enhancements?

Frederik Ramm frederik at remote.org
Wed Jan 11 11:43:13 GMT 2012


On 01/11/2012 11:39 AM, Jason Lee wrote:
> Ten seconds does sound quite slow and I was wondering what can be done
> to improve it. Just out of curiosity, I tried disabling all the 7 Layers
> except for 1 Layer in the Mapnik stylesheet, so the rendering requires a
> lot less db querying and map rendering

To get a definitve answer on how much time is spent in database 
processing, set log_min_duration_statement to 0 (default is -1 = 
disabled) in your postgresql.conf, kill -HUP the database, and re-run 
your request. You'll get durations for every single statement. It is 
very easy to overlook a performance killer here. If you find a statement 
that takes seconds, run an "explain" on it to make sure it uses an 
index, or create an appropriate index if it doesn't.


Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"

More information about the dev mailing list