You can most certainly use matviews http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views http://tech.jonathangardner.net/wiki/PostgreSQL/Material

You can most certainly use matviews http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized... it's not part of pg - but, it is something that you can write yourself due to the awesomeness of plpgsql.