[Tile-serving] [openstreetmap/osm2pgsql] JSONB tags support for slim tables. (#738)

[Lev Dragunov]

OSM tags are very similar to JSON fields. So I think that it will be great to have JSON data representation in database. Postgresql allows indexes on JSON fields and store this data more effectively than plain text arrays.
I made some tests on my dataset (USA East Coast) and have this numbers:

|method|tags size in _ways|tags size in _rels|
|--------|-----------------:|---------------:|
| array   | 4422 mb               |      36 mb         |
| jsonb   | 3805 mb              |      32 mb         |
You can view, comment on, or merge this pull request online at:

  https://github.com/openstreetmap/osm2pgsql/pull/738

-- Commit Summary --

  * JSONB column for tags inside the pgsql middle.

-- File Changes --

    M middle-pgsql.cpp (17)

-- Patch Links --

https://github.com/openstreetmap/osm2pgsql/pull/738.patch
https://github.com/openstreetmap/osm2pgsql/pull/738.diff

-- 
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/738
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170408/0d31ae06/attachment.html>