On Tue, Mar 17, 2015 at 11:48:58AM +0100, Carlos Alberto Castaño Moraga wrote: > Hi Sarah, > > Thank you very much for your answer. Here is the output of the things I had > to check: > > A) run ./utils/setup.php --create-functions > > I think there is no error. Here you can find the output. > > B) Triggers installed (psql nominatim and the '\d placex') > > Triggers: > placex_before_delete AFTER DELETE ON placex FOR EACH ROW EXECUTE > PROCEDURE placex_delete() > placex_before_insert BEFORE INSERT ON placex FOR EACH ROW EXECUTE > PROCEDURE placex_insert() > placex_before_update BEFORE UPDATE ON placex FOR EACH ROW EXECUTE > PROCEDURE placex_update() > > C) check the number of items to be indexed: > SELECT count(*) FROM placex WHERE indexed_status > 0; > > count > -------- > 111900 > (1 row) > > I think everything is OK. What would be the next step??
This looks all perfectly ok. I don't see why it shouldn't work. Just run the following again: ./utils/setup.php --index Afterwards the number of items to be indexed should be 0. If that works, also check if there is an index idx_placex_rank_search on placex. Sarah _______________________________________________ Geocoding mailing list [email protected] https://lists.openstreetmap.org/listinfo/geocoding
