[OSM-dev] [OSM-newbies] Should osm2pgsql create the planet_osm tables?
Andy Allan
gravitystorm at gmail.com
Tue Jan 22 11:48:23 GMT 2008
On Jan 22, 2008 10:15 AM, Alexander Wright
<silverfish at wright-family.me.uk> wrote:
> 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.
The "recreating the indexes afterwards" is the bit that takes an hour,
as Dave explains. It's a lot of data.
Cheers,
Andy
More information about the dev
mailing list