[Tile-serving] [openstreetmap/osm2pgsql] Non moving node updates should not update related way/relation geometries (#1046)

[Christian Quest]

When a node is modified, osm2pgsql does not make a difference if it is just a tag change or a lat/lon change.

When the lat/lon is the same as the actual one in the database, there is no impact on ways and relations refering to that node and their geometry do not need to be updated.

I suggest to add a test in node_modify to check if the lat/lon has changed or not.

The actual code is very basic:
- delete the node from the DB
- set the node location in the cache
- create the node in the DB
- look for related ways/relations and mark them as pending for update as well

It could be more efficient:
- update the node in the DB (UPDATE instead of DELETE/INSERT may also limit DB bloat)
- if location has changed:
  - set the new location in the cache
  - mark related ways/relations as pending for update


-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1046
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200103/dff8367c/attachment.html>