Am 27.06.2010 11:49, schrieb Peter Körner:
The import is now nearly over, it'll take some hours to complete, i
The import is over now. It's still experimental but could offer us some new features:
select osm_id, "wikipedia:" from planet_hc_point where not "wikipedia:" is null limit 50;
select osm_id, "name:" from planet_hc_point where not "name:" is null limit 50;
I did not create all possible indexes (see attached file). The conditional btree indexes allow for a fast search for set fields (see above) while the gin indexed allow for fast key/value lookups.
I already created planet_hc_point_has_wikipedias and planet_hc_point_has_names to test the above two queries.
Peter