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

[Christian Quest]

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.

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