[OSM-dev] osm2pgsql for 64-bit IDs

[Anthony]

On Sun, Jun 5, 2011 at 8:39 AM, Frederik Ramm <frederik at remote.org> wrote:
> Linestrings with internal geometries are very unlikely to happen, for a
> number of reasons, one of them being topology.

That's too bad.  More than 90% of node ids are completely useless as
they refer to only one way.  This is a significant drag on the
database, and especially on imports (especially under the current .osm
format which requires a huge sort and join in order to import into a
form suitable for rendering).

Node ids could still be kept for nodes which reference more than one
relation/way, as well as for POI nodes, but 90% or so of them could
still be eliminated/recycled with very few changes.