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

I have a local global OSM server up and it is running, but the rendering speeds vary drastically. An example:

DEBUG: DONE TILE english 9 216-223 144-151 in 32.009 seconds

DONE TILE english 16 74992-74999 11408-11415 in 304.705 seconds

I have run the indexes from here: OSM PostGIS Tuning and it seems to not have made much of a difference. I would say for Z16 the average render time is about 190 seconds. This is sitting on the following hardware:

  • Intel i9-10850K (20 Core)
  • 128GB DDR4
  • OS is sitting on 1TB NVME
  • OSM Database is sitting on 4TB NVME

Here are my postgres settings (this all sits on postgres 12) some taken from here: osm2pgsql manual:

  • max_connections = 300

  • shared_buffers = 16GB

  • work_mem = 10GB

  • maintenance_work_mem = 10GB

  • autovacuum = on

  • effective_io_concurrency = 300

  • wal_level = minimal

  • fsync = off

  • synchronous_commit = off

  • max_wal_size = 10GB

  • min_wal_size = 80MB

  • checkpoint_completion_target = 0.9

  • max_wal_senders = 0

  • random_page_cost = 1.1

  • effective_cache_size = 70GB

asked 04 Apr '22, 19:09

jaredalv's gravatar image

jaredalv
41225
accept rate: 0%

2

Do you have a Postgres slow query log so you can see (assuming the bottleneck is Postgres) what's taking the longest time?

(06 Apr '22, 10:29) Richard ♦

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×710
×134
×105
×34
×17

question asked: 04 Apr '22, 19:09

question was seen: 981 times

last updated: 06 Apr '22, 21:46

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