NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

We have set up a rendering server with a Intel(R) Xeon(R) CPU E5-1620 v2 @ 3.70GHz, 32 GB RAM and SSD discs for the database storage.

Import was done using osm2pgsql -C14G --number-processes 8 -v --slim planet-latest.osm.pbf and postgresql 9.3 and the settings as suggested by Frederik Ramm.

But the performance on low zoom levels is worse than what Frederik gets in his talk. Maybe because of additional map data in the past 2 years?

Some extreme examples:

Map                           X          Y   Z Prio   Age
example                      32         16   6    1   486

Currently rendering: (num=4)
Map                           X          Y   Z Prio   Age
example                     136         80   8    1   295
example                     128         80   8    1   295
example                     264        168   9    1   285
example                     528        352  10    1   260

I am using the standard osm.xml (mapnik-osm-carto). with the standard bounding box (GB) takes 6m10.450s.

Is this normal?

asked 24 Jun '14, 13:22

Alex_AddisMap's gravatar image

accept rate: 0%

edited 24 Jun '14, 13:31

You've already partially answered your own question: two years ago we had roughly half the data we currently have in the database see for example (I'm actually surprised that you are not still importing given that the cache value you used is far too small for a current planet).

However the queries for low zoom tile data tend to already substantially reduce the ammout of data, so that is likely not to be a major factor. Frederiks numbers seem to be very good, I've not actually ever seen low zoom tiles render as fast as his numbers show. IIRC for the standard style we pre-render down to zoom level 14 to work around that.

permanent link

answered 25 Jun '14, 09:24

SimonPoole's gravatar image

SimonPoole ♦
accept rate: 18%

edited 25 Jun '14, 09:35

Even on zoom level 15 I have the problem that tiles take too long.

(05 Jul '14, 13:14) Alex_AddisMap

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 24 Jun '14, 13:22

question was seen: 3,486 times

last updated: 05 Jul '14, 13:14

NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum