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

Sarah Hoffmann notifications at github.com
Mon Apr 17 14:11:47 UTC 2017


The change is not for making things easier to pass around, it's for retaining the information about the key, to fix issues like https://github.com/openstreetmap/Nominatim/issues/148. Using hstore instead of columns for each address part gives us a lot more freedom down the line to change search and display strategies for placex entries without having to change the database schema again.

Maybe you would like to share the findings of you 'column tetris'? From the numbers it looks like there is still a lot to gain for the placex table even with the new address hstore. If so, please open a new issue in the Nominatim issue tracker about it.

-- 
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-294492745
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170417/9bca705d/attachment.html>


More information about the Tile-serving mailing list