[OSM-dev] Switch osm2pgsql to 64 bit mode

[Kai Krueger]

On Sat, Sep 15, 2012 at 7:59 AM,  <marqqs at gmx.eu> wrote:
> 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).

What version of Ubuntu do you use? I have updated the packages for
12.04LTS (precise), but I haven't updated them for the other versions
of Ubuntu yet.

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

It is an incompatible change, so you will need to delete and re-import
the full database. (But you need to do that anyway for the switch to
ODbL). But if you run osm2pgsql in --create mode, it will
automatically delete the old database for you and change the schema.
So you don't have to worry about that.

Kai

>
> 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