Is it possible to import the planet-190805.osm.pbf in the server with:

8 vcpus, 32 GiB memory, 30GB(SSD)+1TB(SSD) ???

what is the min CACHESIZE for the import?

I got Out of memory with CACHESIZE=8192 and CACHESIZE=4096 during import the Relation.

shell:

export CACHESIZE=???

osm2pgsql --create --slim --hstore --cache ${CACHESIZE} --multi-geometry --unlogged --flat-nodes /var/lib/osm/nodes.cache --hstore-add-index --number-processes 8 --database gis --username osm /mnt/resource/planet-190805.osm.pbf

planet-190805.osm.pbf

Node,Way,Relation
5369694,595461,7041415

asked 03 Sep, 01:15

Nationals's gravatar image

Nationals
1126
accept rate: 0%

even as CACHESIZE=18000,

and CACHESIZE=30000 in another server.

(03 Sep, 01:18) Nationals

I means disable the swap.

(03 Sep, 07:27) Nationals

import the pbf file with : osm2pgsql --create --slim --flat-nodes /mnt/resource/nodes.cache /opt/osm/planet-190805.osm.pbf

then, the file /mnt/resource/nodes.cache must been keep for osm2pgsql --append ?

and will the osm2pgsql --append update the file /mnt/resource/nodes.cache for next running time?

and is the file /mnt/resource/nodes.cache need for mapnik etc.?

flat-nodes osm2pgsql asked 30 Aug, 02:35

Nationals's gravatar image Nationals 11‚óŹ2 accept rate: 0%

edited 19 mins ago

how about the performance different using --flat-nodes or not while osm2pgs

permanent link

answered 03 Sep, 01:53

fon's gravatar image

fon
1
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×213

question asked: 03 Sep, 01:15

question was seen: 174 times

last updated: 03 Sep, 07:27

powered by OSQA