how to optimization the osm2pgsql on Dedicated Server (centos 7)? I have 2 of this testing server with: 1) 8 core, 32G RAM, NVME 512GB 2) 8 core, 64G RAM, NVME 512GB software: Linux (centos 7.6.1810) /etc/sysctl.conf vm.swappiness = 0 /etc/security/limits.conf * soft nofile 1024000 /etc/fstab /dev/mapper/centos-root / xfs defaults,noatime,nodiratime 0 0 sh run: export FLATNODESFILE=/var/osm/nodes.cache export PBFFILE=/mnt/resource/planet-190805.osm.pbf export CACHESIZE=30000 # how to optimization this para on differencce HW export PGPASSWORD=< pg_password > # /usr/local/share/osm2pgsql/default.style osm2pgsql --create --hstore --hstore-add-index --cache $CACHESIZE --multi-geometry --unlogged \ --flat-nodes $FLATNODESFILE --number-processes 8 -v \ --host < PG_Server_IP > --port 5432 --database gis --username osm $PBFFILE any other optimization are need? asked 02 Sep '19, 03:53 Nationals |
I suggest to set answered 02 Sep '19, 08:29 Frederik Ramm ♦ PG SQL is on another Dedicated Server with 1TB NVME.
(02 Sep '19, 10:53)
Nationals
|
DateFile Node Way Relation
190722 5330978k 591991k 6917050