Stefan Keller <sfkel...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers