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?
