patternsqlMinor
Materialized View PostgreSQL
Viewed 0 times
postgresqlmaterializedview
Problem
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...
I don't want Gardner version or somehthing like physical table populated by triggers.
I've read that was/is something being deploy...
Solution
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.Context
StackExchange Database Administrators Q#36047, answer score: 6
Revisions (0)
No revisions yet.