PostGis Spatial Index

Creator

Creator

Seonglae Cho

Created

Created

2020 Nov 20 1:16

Editor

Editor

Seonglae Cho

Edited

Edited

2023 Sep 13 12:18

Refs

Refs

PostGis Cluster Spatial Index


CREATE INDEX geom_index
  ON "42dot".recorded
  USING GIST (geom)

15. Spatial Indexing - Introduction to PostGIS

Recall that spatial index is one of the three key features of a spatial database. Indexes make using a spatial database for large data sets possible. Without indexing, any search for a feature would require a "sequential scan" of every record in the database.

https://postgis.net/workshops/postgis-intro/indexing.html

15. Spatial Indexing - Introduction to PostGIS

Recommendations

/////////