[Tile-serving] [openstreetmap/osm2pgsql] New middle tables experiments (Issue #1970)

[Jochen Topf]

> created should be timestamptz because it is a UTC time

No. See #1785.

> fastupdate=off ...

I just took those settings from the old setup. If we don't need those, we should remove them everywhere. There is an open issue #37 about fastupdates. I never got around to researching this, but having nothing against remove them.

> What schema will be used for the various jsonb columns?

Tag columns just have the obvious key-value structure. For relation members I showed the structure in the PR: `[{"type": "W", "ref": 123, "role": "inner"}, ...]`.


-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1970#issuecomment-1565681676
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1970/1565681676 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230527/5b3d4366/attachment.htm>