...
This needs to be substantially refined for production.
The following section should address this in complete detail.
Server Configuration
The EAS databases need to support 3 sorts of activities
- modest OLTP actvity (mad database)
- heavy weight overnight ETL activity (sfmaps, mad databases)
- heavy read processes from geoserver to produce web maps (sfmaps database)
The host VMs for the DB have 8GB of RAM.
Here I discuss the settings in the postgresql.conf file.
The default settings are for low resource environments and will result in relatively poor performance.
These seetings are my "best guess".
We'll need to do some monitoring in PROD to tune these values.
- shared_buffers: 500MB
- work_mem: 16MB
- maintenance_work_mem: 128MB
- wal_buffers: 1MB
- checkpoint_segments: 6
- random_page_cost: 2
- seq_page_cost: 1
Do not forget to reload or restart for these configurations to take affect.
Links
- http://workshops.opengeo.org/postgis-intro/tuning.html
- http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Security - Production
The dataserver should be accessible only from the following:
...