This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Using osmosis update OSM Planet extreamly slow.

0
  • osmosis version: 0.46-2
  • osm2pgsql version: 0.94
  • Ubuntu version: 18.04.2

PostgreSQL config:

  • shared_buffers = 12G
  • work_mem = 1000MB
  • effective_io_concurrency = 2
  • fsync = on
  • autovacuum = on
  • effective_cache_size = 12GB
  • maintenance_work_mem = 2GB

Using osmosis to update the planet osm database. Based on this tutorial:Updating your database as people edit OpenStreetMap

I modified the osm2pgsql script in mod_tile/openstreetmap-tiles-update-expire to this

osm2pgsql -slim -a --flat-nodes /node.cache --cache 3000 -e 13-20 <database config, user, host etc> -o /dirty_tiles /changes.osc.gz

Is the "-e (expire tiles)" slows down the importing? If I only want to update the database but don't want to update the image tiles, can I just remove the -e and -o argument?

alt text

You can see the processing speed is really slow!

asked 09 Dec '20, 18:52

Yingcai's gravatar image

Yingcai
11225
accept rate: 0%

edited 09 Dec '20, 18:56

Source code available on GitHub .