Materialized View PostgreSQL

Materialized View PostgreSQL

Is there any possibility of having built-in materialized views in PostgreSQL ?
I don't want Gardner version or somehthing like physical table populated by triggers.
I've read that was/is something being deploy...


Answer 1:

A basic version of materialized view are being delivered in 9.3, see depesz’s article. However, it’s a very limited version as you have to call REFRESH MATERIALIZED VIEW to get the database to update the view. This will hopefully improve to become automatic in later versions soon.

Our Awesome Free Tools