[OSM-dev] [OSM-newbies] Should osm2pgsql create the planet_osm tables?

Jon Burgess jburgess777 at googlemail.com
Tue Jan 22 19:03:15 GMT 2008


On Tue, 2008-01-22 at 11:11 +0000, Dave Stubbs wrote:
> I think this is effectively what it's doing (it uses a postgres COPY
> statement too). Unfortunately there are about 10 million ways in the
> DB being added to GIST index, and it takes a while on my box as
> there's only 1GB RAM. 
> 
> I haven't looked at that part of the code in much detail either... I'm
> guessing it isn't doing anything particularly silly though, and before
> the tiger import it worked in a very reasonable amount of time. 
> 
Artem suggest I add a bounding box option to filter the planet during
the import. This would help make things a lot faster if you only want a
subset of the data. I've added it to my TODO list.

	Jon






More information about the dev mailing list