[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:
> 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