Hi Brian, currently I'm stuck indexing the whole planet and don't know what's going on. For at least some days pgstat shows that the database is working on update placex set indexed = true where not indexed and rank_search = 25 and name is not null; Whenever I ask for select count (*) from placex where not indexed and rank_search = 25 and name is not null; i get a result of 74241 like there is no progress at all. Today I stopped the process, restarted postgresql and restarted the rank 25 index. While postmaster takes up to 100% of the CPU, my count results are always the same.
Shouldn't the number of unindexed rows decrease in a while or am I too impatient? Is there any documentation of the rank_search indexes and what the stand for that I have overlooked? Kind regards Frans
_______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
