[OSM-dev] Importing planet file with osmosis into PostgreSQL

Frank Bielig Frank.Bielig at OneStepAhead.de
Sun Dec 13 12:35:39 GMT 2009

Many thanks for fast and valuable responses. One more open question I have.

Currently I need about four days for importing the whole planet file. Is 
that a normal computing time? The bottleneck seems to be the database 
(PostgreSQL). Are there any hints for the database configuration? For 
conversion I use  a quadcore machine with 8GB RAM. Data files are 
located on an own hard drive.

> Hi,
> Lennard wrote:
>> I thought that was fixed, and the dump now runs in a transaction?
> No; many seem to think it is fixed but simple inspection of the current 
> planet file tells you that the highest node id therein is 583444559 
> (added 2009-12-09T01:19:27Z), whereas the highest *referenced* node id 
> is 583482866 (used by way 45846092 which was added 2009-12-09T07:13:04Z).
> Bye
> Frederik
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev

Frank Bielig               Tel:   +49 33398 687848
OneStepAhead AG            Fax:   +49 33398 687849
Research & Development     Mobil: +49 177 3339868
Leuschnerstr. 45           eMail: Frank.Bielig at OneStepAhead.de
D-70176 Stuttgart          Web:   http://www.OneStepAhead.de

Firma:                     OneStepAhead AG
Firmensitz/Amtsgericht:    Stuttgart, HRB 22686
Vorstand/Vorsitzender:     Nihat Kücük
Aufsichtsratvorsitzender:  Prof. Dr. Reinhold von Schwerin

More information about the dev mailing list