Materialized Views in Postgres
I got a lot of great feedback on my tutorial at PGCon. The slides, as well as a sample chapter from my upcoming O’Reilly Book are posted on the PGCon web site. You can also grab them here:
- Slides from PGCon 2008: Materialized Views That Work.
- Sample Chapter: Materialized Views from Enterprise Rails (O’Reilly Media).
I highly recommend the sample chapter, as it takes you through an example in prose form. The slides from the talk are pretty content-heavy but some code slides may be difficult to grasp without commentary.
Thanks for the cite and reference to my work at http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views. Yes, it is quite popular. I haven’t really touched it for some time now, but I’m not surprised that it’s still useful.