[Tile-serving] [openstreetmap/osm2pgsql] Use SP-GiST indexes when available (#1357)

[Paul Norman]

> I can see how clustering based on the spatial index would not be as good as the Hilbert curve's results as created by an 'ORDER BY way' clause, but it does seem to result in at least significantly more spatially coherent data. The first image below is a fetch of the first 5000 records as shown in DBeaver, and as returned from a much larger Germany dataset with OpenStreetMap's main road classes, and clearly shows signs of severe spatial fragmentation after the particular processing done on the dataset. The second image shows a similar 5000 record fetch of the same dataset after spatial defragmentation using CLUSTER with the spatial index as input.

If you're getting this behavior, can you open up a new issue with details including the osm2pgsql command line, postgresql and postgis versions, and testing methods.

-- 
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/issues/1357#issuecomment-752734085
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20201230/67977011/attachment.htm>