On 17.12.2011 23:38, Kay Drangmeister wrote:
Of course it is a space advantage not to repeat each tag existing in a regular column in the "tags" hstore again, but on the other side, stylesheets have to be always adapted if the osm2pgsql config file is changed. Plus they will no longer be portable across servers with different osm2pgsql configurations.
Would it be possible to re-import the hstore?
There had been rumors that accessing hstore "columns" is slower than regular columns. Anyone done some tests regarding this?
So performance-wise it might be better to adjust styles. It should be a simple search-replace. It could even be automated so it replaces hstore columns with native columns.
Stephan