Re-posted from stackoverflow: I'm importing the whole-planet OSM data set into PostgreSQL 9.6.2 on a Amazon EC2 i3.4xlarge (122 Gb mem, 16 CPUs) with the PostgreSQL data directory on a throughput-optimized 2TB volume. I have adjusted Postgres parameters like this (for the import):
I'm using
The initial steps of the import have gone extremely fast, but its been sitting at Following the advice in this post I looked for the table Does this sound normal? This is time-sensitive and having already been waiting the better part of a week, I am a little worried something has wrong. Are their other Postgres settings that could speed this part of the process? asked 01 May '17, 14:35 rgwozdz |
How long did the rest of the import take? IMHO I would wait for the indexing to complete, it is a rather large part of the total time used, and will complete at some point in time. Note: the reference to a place table is a red herring, that is used for imports in to the Nominatim schema, not the normal osm2pgsql tile rendering schema. answered 01 May '17, 18:31 SimonPoole ♦ 1
@SimonPoole - the portion of the import prior to the phase it is currently on took about 24 hours.
(01 May '17, 18:37)
rgwozdz
1
Eventually finished, took several more days. Failed on next step because max_connections were too low for that many processors. Success after increasing max_connections.
(11 May '17, 14:52)
rgwozdz
|