In this chapter, we will cover the following recipes:
- Organizing the database
- Setting up the correct data privilege mechanism
- Backing up the database
- Using indexes
- Clustering for efficiency
- Optimizing SQL queries
- Migrating a PostGIS database to a different server
- Replicating a PostGIS database with streaming replication
- Geospatial sharding
- Paralellizing in PosgtreSQL