Another alternative is to modify the optimizer to introduce the materialized view when applicable, even if it is not explicitly used in the query (we discussed this in the query optimization chapter).
For more information, see http://wiki.postgresql.org/wiki/Materialized_Views and also http://archives.postgresql.org/pgsql-hackers/2010-04/msg00479.php