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

Alexander Wright silverfish at wright-family.me.uk
Tue Jan 22 10:15:49 GMT 2008


On Tuesday 22 January 2008 09:55:23 Dave Stubbs wrote:
> On my box this takes several hours for the latest planet, and spends at
> least an hour with no output as postgres is indexing the data.

I've not seen the insert code, so please ignore me if this is done already!
I believe that if you are importing large amounts of data, its usually better 
to drop indexes on a table, insert the data, the recreate the indexes 
afterwards.

I'm quite prepared to believe there is a good reason for not doing this, 
though.

Alex Wright.






More information about the dev mailing list