Hi Folks,
i started a planet import with the additional hstore column. It allows
us to retrive and search in all tags used in osm. I used a combined
hstore/column scheme, as our tests on the german devserver showed that
hstore-value-conditions are much slower than the column-conditions of
the classic database layout.
If the import is over, i'll come back with some sample queries.
The import is running on ptolemy using the following command:
$HOME/src/osm2pgsql/osm2pgsql \
--slim \
--cache 3000 \
--merc \
--prefix planet \
--style $HOME/src/osm2pgsql/default.style \
--host sql-mapnik \
--database osm_mapnik \
--hstore \
--extra-attributes \
$HOME/data/planet-100505.osm.bz2 2>&1 | \
tee $HOME/planet_osm_hstore_import.log
I'm planning to switch the ddiff update process to this database after
the import and to drop the old, classic database.
Peter