[postgis-users] GIST index speed

Markus Schaber schabi at logix-tt.com
Thu Jun 5 02:38:20 PDT 2008

Hi, Brian,

"Peck, Brian" <brian.peck at lmco.com> wrote:

> As far as I know we did not compile with debugging on, and swapping to
> contains did not speed things up. However we are not using ST_Contains()
> [just contains()]. These don't exist in the database (either the 8.2 I
> am testing on - or an upgraded 8.3 I use locally)

Whether the ST_ functions exist does not only depend on the PostgreSQL
version, but also on the PostGIS version.

Try: select version(),postgis_full_version();

This tells you the PostgresQL version and PostGIS version with all
relevant details.


Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org

More information about the postgis-users mailing list