On Jan 22, 2008 11:15 AM, Alexander Wright <[EMAIL PROTECTED]> wrote: > 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.
It does do it. Within a single transaction the tables and indexes are dropped, recreated, data inserted, indexes created. The new data appears atomically. It just takes a really long time. Which version of postgres you use also matters. Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
