[Tile-serving] [openstreetmap/osm2pgsql] Gazetteer: use hstore column for address parts (#737)

[Christian von Roques]

I can understand why we don't want to ignore / throw away any of the `addr:*` information; After all, there probably was a reason why it was entered in the first place. However, can't we have both, efficient storage for the common case and no lost information? You could use columns for the "usual" address information which is already explicitly interpreted, like `addr:housenumber`, `addr:street`, `addr:place`, `isin` and store all other, currently uninterpreted `addr:*` fields in the new HSTORE column, making it NULL in the common case?

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/737#issuecomment-294902706
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170418/36f6fa27/attachment.html>