[OSM-dev] disk size for planet osm import into PostGIS (on an SSD)?
Akos Maroy
akos at maroy.hu
Thu Jun 27 08:08:39 UTC 2013
Frederick,
>
>> I'd like to inquire about the estimated disk size needed to import the
>> planet osm file into PostGIS?
>
> 320 GB on a machine I am running.
reassuring to hear :)
>
>> /usr/local/bin/osm2pgsql -d osm_world -s -C 5800 --hstore-all -K -v -G
>> -m planet-130620.osm.bz2
>
> I use --flat-nodes which saves more than 50 GB and is quicker. I don't
> use -K, and I don't use --hstore-all either; both will certainly blow
> up the space needed. I recommend using a shape file for coastlines
> like everyone else does, and to have a look at --hstore-match-only
would this be --hstore --hstore-match-only ?
> (you really don't need stuff *twice* in your database) and use a
> stripped style.xml that ensures you don't store tons and tons of
> "note" and "source" tags and other import side products. You don't
> want to burden your SSD with tags like "gnis:Class", "NHD:FType",
> "tiger:PCICBSA", or "canvec:UUID" ;)
indeed
thanks for the ideas
Akos
More information about the dev
mailing list