On Mon, Jul 20, 2009 at 12:00 PM, Ævar Arnfjörð
Bjarmason<ava...@gmail.com> wrote:
> 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)
Did you build a spatial index on any of the tables? That would add
substantially to the database size, yet would improve performance and
rendering.
-Kate
>
> _______________________________________________
> talk mailing list
> talk@openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
>
_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk
