[Geocoding] monitoring the progress of the installation

[Brian DeRocher]

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