search

drolbr / Overpass-API

A database engine to query the OpenStreetMap data.
http://overpass-api.de
GNU Affero General Public License v3.0
692 stars 90 forks source link

Change_Entry: old_idx and new_idx unused? #654

Closed mmd-osm closed 1 year ago

mmd-osm commented 2 years ago

I was wondering a bit about a use case to have old_idx and new_idx in the Change_Entry structure. Obviously, they're only being written in {node, way, relation}_updater, but never read again anywhere else. The "changed" statement as single consumer of changelog tables extracts the element id, and ignores old_idx and new_idx.

Those extra 8 bytes consume quite a bit of space given that we have more than 8 billion changelog entries for nodes. Is there some special use case for those two fields, like debugging or troubleshooting? Are they really needed at all?

mmd-osm commented 1 year ago

If I see this right, both old_idx and new_idx have been removed in 0.7.60 now. So I guess there was really no need to keep them around.