Here we provide the details of the Linux VM on which we deploy PostgreSQL.
| Table of Contents |
|---|
Context
...
We ...
- have very little linux admin expertise
- we are linux users (bash, vi, sed, awk, grep, etc does not scare us)
- have few resources (money, people, time)
So...
- simple is important
- automation is importantthe
The application is...
- not huge
- not complex
- not particularly resource intensive
- the overnight ETL and map tile generation is the most demanding portion of the appliation
- we expect to update and insert an average of 10-100 "street address records" per day
- there will be 10s of thousands of reads per day (generate mailing lists)
- there will be a modest amount of spatial processing (nearest streets, point in polygon, nearest addresses)
- there is currently no known performance issue with the application
...