Stefan Keller <sfkeller@gmail.com> writes:
> There seems to exist some opportunities now with GIST which relate to
> geometry/geography types (but not only...):
> 1. Index-only scans on geometry columns with SP-GIST (being able to do
> a "SELECT id FROM my_table WHERE mygeom...;").
Well, if somebody builds an SP-GiST opclass for geometry, that should
work.
> 2. Index clustering incuding NULL values (i.e. being able to do a
> "CLUSTER mygeom_index ON mytable;" ).
Huh? GiST has supported nulls, and CLUSTER, since 8.2 or so. The
section of the PostGIS manual you're referring to seems to be years
out of date.
regards, tom lane