New answers tagged


By default shp2pgsql does NOT create indexes. You need to pass -I to make it generate a spatial index. Check if your table has an index by running \d tablename in psql. In the list of indexes should be a line with "gist" (unless you picked a different index) and your geometry column name. You can add ...

Top 50 recent answers are included