[OSM-dev] Switch osm2pgsql to 64 bit mode

marqqs at gmx.eu marqqs at gmx.eu
Sat Sep 15 14:59:33 BST 2012


Thank you for you work!

When will this new version be available via your repository? I just tried and got the old one (0.80.0).

Do I need to delete and remove the old database first, or will it be modified and reused by the 64-bit osm2pgsql?

Grüße
Markus

-------- Original-Nachricht --------
> Datum: Thu, 13 Sep 2012 16:58:45 -0600
> Von: Kai Krueger <kakrueger at gmail.com>
> An: dev at openstreetmap.org
> Betreff: [OSM-dev] Switch osm2pgsql to 64 bit mode

> Hello everyone,
> 
> I have just changed the default compile of osm2pgsql to use 64bit IDs 
> instead of 32bit IDs.
> 
> The current highest node ID is 1.9 billion. As signed 32 bit ints can 
> only hold ~2.1 billion IDs, it is likely that the (signed) 32bit ID 
> space will run out in a couple of months.
> 
> As the switching from 32bit to 64bit IDs with osm2pgsql requires a fresh 
> import as the database schemas are not compatible with each other, the 
> current time seems like the most reasonable time to do this, as due to 
> the license change it is recommended to perform a re-import anyway.
> 
> It is still possible to compile osm2pgsql with 32bit IDs by passing the 
> argument --disable-64bit-ids to ./configure.
> 
> According to Frederik's benchmarks[1], 64bit mode is slightly slower and 
> uses up more disk space, but hopefully that doesn't cause to much 
> trouble and it will soon be necessary anyway.
> 
> I also bumped the version number to 0.81.0
> 
> Kai
> 
> [1] http://www.remote.org/frederik/tmp/ramm-osm2pgsql-sotm-2012.pdf
> 
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev



More information about the dev mailing list