Hi
I'd like to start a new planet import using the new --hstore-column feature of osm2pgsql. It would allow us to have a "name:" column, containing all translations and thus allow better rendering of translated objects.
I'll run it directly on ptolemy into the existing osm_mapnik database but with a different prefix. The exact command is
time ./osm2pgsql \ --slim \ --cache 2000 \ --style default.style \ --prefix planet_hc \ --host sql-mapnik \ --database osm_mapnik \ --hstore \ --hstore-column "name:" \ --hstore-column "addr:" \ --hstore-column "wikipedia:" \ $HOME/data/planet/planet-100623.osm.bz2
Peter
Peter Körner writes:
I'll run it directly on ptolemy into the existing osm_mapnik database but with a different prefix.
Is it already running? Is there already an estimated completion time? Queries during the import might be considerably slower, also tile creation would be impacted by DB speed.
Stephan
The import is now nearly over, it'll take some hours to complete, i think. It could make our multilingual tile-rendering much faster. Sorry if it made other tools noticably slower.
Peter
Am 25.06.2010 19:15, schrieb Stephan Knauss:
Peter Körner writes:
I'll run it directly on ptolemy into the existing osm_mapnik database but with a different prefix.
Is it already running? Is there already an estimated completion time? Queries during the import might be considerably slower, also tile creation would be impacted by DB speed.
Stephan
Maps-l mailing list Maps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/maps-l
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