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

[Iván Sánchez Ortega]

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.


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

For office use only.