Page Comparison

Here we provide the details of the Linux VM on which we deploy PostgreSQL.

Context

• we have very little linux admin expertise
• we are linux users (bash, vi, sed, awk, grep, etc)
• simple is important
• automation is important
• the application is not huge, not complex, not demanding of resources
• 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

...