- Hot standby
- Materialized views
- Synchronous replication
- Parallel queries
- Better administration and monitoring tools
I remember many years ago, materialized views were a somewhat hot topic, but things have cooled down significantly now. In a broader sense, materialized views are queries caches, and I did hear something about that at PGCon. In the meantime, Jonathan Gardner's article Materialized Views in PostgreSQL appears to remain the most frequently cited treatment on the subject. (The original link is down, unfortunately.) The PGCon 2008 tutorial Materialized Views that Really Work by Dan Chak is also worth looking at.
So, who's up for implementing built-in materialized views/query caching?
Also, if you haven't done so, submit your suggestions and votes at the UserVoice forum.