For #2, there are plenty of managed PG services (AWS RDS, Heroku, etc) if you have trouble with the sysadmin.
For #4, Postgres has materialized view support in 9.3 with some improvements in 9.4.
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_...