Tuesday, 11 October 2016

postgis 2.0 - PostGIS2 have automatic BBOX indexing?


I need to compare millions of geometries by the && operator (BBOX).



When CREATE TABLE see geometry type on PostGIS2, it do also something like INDEX ON t USING GIST(g)? or I need to express, always, the CREATE INDEX in (or after) my CREATE TABLE?


If it is automatic, it is for any field name (or only for "geom")?




PS: (if no index is automatically crated) when I use ST_DWithin(A,B) PostGIS generate a temporary index?




No comments:

Post a Comment