[OSM-dev] speeding up loading an OSM dump into PostGIS?

Iván Sánchez Ortega ivan at sanchezortega.es
Thu Dec 1 09:15:26 GMT 2011

On Thu, Dec 01, 2011 at 07:14:29AM +0100, Yves wrote:
> Really?
> What is a decent server ?

We're using (I think) a 64-bit quad-core VM with 6 gigs of ram and about ~100 GB of
disk. With a close-to-default feature filter (see imposm docs on mapping
files) it takes between 48 and 50 hours.

In comparison, the same server took about 10 days to load a full planet into
a 200GB PostGIS DB. The bad thing about this kind of DB is that you don't
need the whole dataset to render maps, and SQL queries slow down to a crawl
with the hstore indexes. Having separate tables, as imposm does, is much more
practical for rendering purposes.

Iván Sánchez Ortega <ivan at sanchezortega.es> <ivan at geonerd.org>

For office use only.

More information about the dev mailing list