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

[mboeringa]

> I've reindexed my planet database right after an initial import.
> 
> The size benefit is clear, almost 1/3 of GIST index (except for planet_osm_point).
> The spped benefit is also there; started indexing during the initial import, the spgist finished before the gist ones.
> 
> All tests done with PG 13 and postgis 3.1.
> 
> All my conditionnal indices are now spgist too, with the same benefit.

What about speed of actually using SP-GIST versus GIST indexed data, e.g. during rendering in some toolchain, or display in e.g. QGIS? Do you have any experiences to share? E.g. I know from experience that using BRIN significantly slows down spatially accessing Polygon and Line type data in a GIS.

-- 
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-909931034
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210831/19e1ee63/attachment.htm>