[Geocoding] gazetteer-index.sql explained

[Frans Hals]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20100123/6ca8d242/attachment.html>