I just wanted to share some ideas i had. It was taking Nominatim forever (3+ weeks easy) to index my tables and i had no idea of it's progress, other than the size of the table. When i discovered that i was only 10% done, i cancelled the import and re-tuned PostgreSQL.
I'm running the import again, this time i took one line [1] and broke it up into parts [2]. [1] insert into placex select * from place where osm_type = 'W'; [2] insert into placex select * from place where osm_type = 'W' and osm_id % 100 = $1; Then i run it from the command line, 1 percent at a time. Each percent takes about 20 minutes longer than the previous percent. So it will take a while, but at least i know it's progress. So i wonder how long it takes others to import/index these tables. Also i wonder if indexing tables after the import is faster. thanks, Brian -- http://brian.derocher.org _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
