Stuck at this step sudo make import-sql area=planet-latest

Following the indications found here: Fast Scalable Basemap with TileServer GL/OpenMapTiles (Ubuntu 22.04)
I’m trying to build the map of the entire world

I first tried the whole process for a small data, the Isle of Man, and everything works fine

But with the data of the entire world, I’m stuck at this sub-step, of step 8 :

root@vmi1046457:~/openmaptiles# sudo make import-sql area=planet-latest

Time: 1.587 ms
psql:/sql/parallel/water__waterway.sql:1016: NOTICE:  schema "waterway_important" already exists, skipping
CREATE SCHEMA
Time: 9.567 ms
psql:/sql/parallel/water__waterway.sql:1027: NOTICE:  relation "changes" already exists, skipping
CREATE TABLE
Time: 39.958 ms
CREATE FUNCTION
Time: 197.301 ms
psql:/sql/parallel/water__waterway.sql:1048: NOTICE:  relation "updates" already exists, skipping
CREATE TABLE
Time: 1.386 ms
CREATE FUNCTION
Time: 10.781 ms
CREATE FUNCTION
Time: 54.163 ms
CREATE FUNCTION
Time: 13.839 ms
CREATE TRIGGER
Time: 159.570 ms
CREATE TRIGGER
Time: 1100.683 ms (00:01.101)
CREATE TRIGGER
Time: 42.035 ms
CREATE TRIGGER
Time: 71.131 ms
CREATE FUNCTION
Time: 18.919 ms

This step is very cpu-intentive : the 10 vcpus usage is within the this range :75% - 99%

The VPS I’m using of a Cloud Service Provider has the following features:

A 10 core CPU
60 GB RAM
1.6 TB Intel Optane SSD

Are these technical features enough for importing into postgresql DB the data of the entire world?
What can I do to make this step : sudo make import-sql speed up and finish?

1 post - 1 participant

Read full topic


Ce sujet de discussion accompagne la publication sur https://community.openstreetmap.org/t/stuck-at-this-step-sudo-make-import-sql-area-planet-latest/6843