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