[OSM-talk] How big should a planet.osm->osm2pgsql database be?

[Ævar Arnfjörð Bjarmason]

Should the PostGIS database imported from the Planet.osm using
osm2pgsql be only 13 GB? Someone else who imported it on #osm-dev
reported a size of 48 GB.

Here's how I imported it:


$ md5sum planet-090715.osm.bz2
c89227585338c72dfcf4ff5d2aaacf53  planet-090715.osm.bz2

Imported with:

$ osm2pgsql -d gis -U avar -W -S ./wikimedia.style planet-090715.osm
$ osm2pgsql -d gis-osm-like -U avar -W -S ./default.style planet-090715.osm

gis=# select pg_size_pretty(pg_database_size('gis-osm-like'));
 pg_size_pretty
----------------
 13 GB
(1 row)

gis=# select pg_size_pretty(pg_database_size('gis'));
 pg_size_pretty
----------------
 15 GB
(1 row)