[Tile-serving] [openstreetmap/osm2pgsql] Don't use ST_GeoHash for ordering (#1016)

[Paul Norman]

At the time GeoHash was adopted, the geometry type
ordering was by x, and GeoHash gave an ordering by
a morton curve. In PostGIS 2.4 the implementation
changed and ORDER BY way also gave a morton ordering.
Now with 3.0 ORDER BY way uses a more spatially
coherent hilbert curve, which gives even better
query performance.

Ref: https://info.crunchydata.com/blog/waiting-for-postgis-3-hilbert-geometry-sorting
You can view, comment on, or merge this pull request online at:

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

-- Commit Summary --

  * Don't use ST_GeoHash for ordering

-- File Changes --

    M src/table.cpp (10)

-- Patch Links --

https://github.com/openstreetmap/osm2pgsql/pull/1016.patch
https://github.com/openstreetmap/osm2pgsql/pull/1016.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/1016
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20191204/efe25789/attachment.html>