|
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. |
|
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. 1
What data can I drop? And is there no way to exclude that data needed for updates?
(24 Sep '12, 13:29)
Alex_AddisMap
1
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
|
