HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Materialized View PostgreSQL

Submitted by: @import:stackexchange-dba··
0
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...

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.