CREATE INDEX geography_gdx ON schema.table USING GIST (geog);
CREATE INDEX geography_gdx ON schema.table USING SPGIST (geog);
 ERROR: data type geography has no default operator class for access method "spgist" Hint: You must specify an operator class for the index or define a default operator class for the data type.
geog is of type
geography. The docs mention an example for
geometry but do not explicitly exclude
Questions: Is there a way to use a SPGiST index on
geography? Or is that not feasible due to the spherical nature of the data?
Note: PostGIS version
POSTGIS="2.5.0 r16836" [EXTENSION] PGSQL="110" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.2.0, released 2017/04/28" LIBXML="2.9.4" LIBJSON="0.12.1" RASTER