On Jan 22, 2008 10:15 AM, Alexander Wright <[EMAIL PROTECTED]> 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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
