Meddo recommends some custom indexes to speed up rendering. These are included as indexes.sql in the repo, but can also be created by scripts/indexes.py
The script has a few useful options for operating on a production server
optional arguments:
-h, --help show this help message and exit
--concurrent Generate indexes CONCURRENTLY
--fillfactor FILLFACTOR
Custom fillfactor to use
--notexist Use IF NOT EXISTS (requires 9.5)
--reindex Rebuild existing indexes--reindex does the set of statements to rebuild an index without locking:
ALTER INDEX roads_low RENAME TO roads_low_old; CREATE INDEX CONCURRENTLY roads_low ON roads USING GIST (way) WHERE class >= 'tertiary'; DROP INDEX roads_low_old;
I'm not sure where we want to put index creation.