[OSM-dev] osm2pgsql for 64-bit IDs

Jochen Topf jochen at remote.org
Sat May 21 15:52:21 BST 2011

On Sat, May 21, 2011 at 12:52:04PM +0200, Frederik Ramm wrote:
> On 05/21/2011 03:53 AM, Igor Brejc wrote:
> >Can you give some rough estimates on how much time we still have until
> >this 64bit issue comes up?
> My rough estimate would be that it *may* happen around the end of
> this year, but more likely around mid-2012. Of course this depends
> heavily on how good we are at stopping data importers going crazy
> ;-)
> Just look at http://wiki.openstreetmap.org/wiki/File:Osmdbstats2.png
> and ask yourself when that line reaches ~2 billion (take into
> account that the line only indicates the number of visible nodes;
> the highest node id tends to be about 20% higher than the number of
> visible nodes).

If we use unsigned ints we have some more time. Problematic would only be
a few cases where negative IDs are currently used (like in JOSM for data
thats not yet uploaded to the server). But it seems wasteful to me, to go
to 64bit a year or so earlier than needed to accommodate this case.

Jochen Topf  jochen at remote.org  http://www.remote.org/jochen/  +49-721-388298

More information about the dev mailing list