Adds a step to the sample data importer to index the geometry columns.
Notes
I didn't really investigate whether query speed is a bottleneck right now, so I don't know if this makes a measurable difference in overall performance. It seems like a no-brainer, so trying to answer that question doesn't seem worth the trouble.
I created the indexes by hand on our test RDS instance.
This came up in discussion around issue #64, but there's no issue open for this particular change.
Testing Instructions
If you don't already have a database container, bringing one up (with scripts/update --download) will import the tables and add the indexes.
If you already have a database container with the data loaded, run docker-compose exec database bash -c "./load_sample_data -f" to reload the data.
Run scripts/console database and inspect the tables to see that they now have indexes on the geom column.
Overview
Adds a step to the sample data importer to index the geometry columns.
Notes
Testing Instructions
scripts/update --download
) will import the tables and add the indexes.docker-compose exec database bash -c "./load_sample_data -f"
to reload the data.scripts/console database
and inspect the tables to see that they now have indexes on thegeom
column.