NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

How much disk space is required for importing the current OpenstreetMap binary data of the whole planet to PostgreSQL database with OSM2Pqsql?

RAM size would be 32 GB.

asked 24 Sep '12, 12:02

Alex_AddisMap's gravatar image

accept rate: 0%

edited 24 Sep '12, 12:54

About 230 GB if you use the new "flatnode" storage, or about 300 GB otherwise. Numbers are for 64bit IDs and "slim" mode which is the only mode available for that amount of memory. If you don't need updates, the temporary storage space is the same, but you can drop a lot of data afterwards, leaving you with only about 80 GB for the full planet.

permanent link

answered 24 Sep '12, 13:06

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
accept rate: 23%


What data can I drop? And is there no way to exclude that data needed for updates?

(24 Sep '12, 13:29) Alex_AddisMap

osm2pgsql takes the standard OpenStreetMap model of nodes ways and relations and turns them into geometries (points, lines, polygons). For diff imports it still needs the node way and relation info, so it needs to store it on disk. Likewise, if you don't have enough ram to keep them in memory during the import it needs to temporarily store the info in the database and then delete it in the end if you don't need it for diff import anymore. Osm2pgsql will do this automatically with the --drop option

(24 Sep '12, 15:54) apmon

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 24 Sep '12, 12:02

question was seen: 4,018 times

last updated: 24 Sep '12, 15:54

NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum