Our team recently found itself in a situation where we needed to write a database query to:

• Union several tables together
• Filter out some rows
• Sort the unioned set different ways

This was going to be a very expensive and slow query. Read more on An Introduction to PostgreSQL Materialized Views…