Using osmosis update OSM Planet extreamly slow.
- 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][1]
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][2]
You can see the processing speed is really slow!
[1]: https://wiki.openstreetmap.org/wiki/User:SomeoneElse/Ubuntu_1804_tileserver_load#Updating_your_database_as_people_edit_OpenStreetMap
[2]: https://help.openstreetmap.org/upfiles/2020-12-09_12-57-19.jpg