...
- relatively high I/O because it's geospatial
- modest light OLTP actvity from single django web application
- most connections from single django web application (no connection pooling)
- modest small number of simultaneous connections (estimate max of 50)
- significant heavy write activity during overnight ETL activity (sfmaps, mad databases)processes
- heavy read processes from geoserver to produce web maps (sfmaps database), especially during cache seeding
The host VMs for the DB have 8GB of RAM.
Until we have some real metrics, let's set aside 2GB for the OS and assume we have 6GB for the DB.
...