[Tile-serving] [openstreetmap/osm2pgsql] Full Planet over inflated db size (#579)

[ImreSamu]

>from what i read i should be keeping vacuum off during large imports,
I mean -  after the imports  -  reclaiming storage occupied by dead tuples.

> i just didn't think it takes that much space to complete today's planet import,

imho ~400 Gb is normal.
in 2015 - the db size was:  
 * http://www.grulic.org.ar/~mdione/glob/posts/osm-planet-importing-and-rendering-times/

you can: 
* filter the planet data : 
  * http://wiki.openstreetmap.org/wiki/Osmfilter
  * https://github.com/gmgeo/osm-carto-lowzoom
  * ...
* or you can use continent  or country extracts :  http://download.geofabrik.de/index.html
* or you can use  the new :  "simplified osm2pgsql database dump"
 *  https://lists.openstreetmap.org/pipermail/dev/2015-July/028625.html



---
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/579#issuecomment-223081771
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20160601/f126e263/attachment.html>