[OSM-dev] Importing planet file with osmosis into PostgreSQL
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.
> 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).
> dev mailing list
> dev at openstreetmap.org
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