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

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...