CODEWITHSUNDEEP
postgresqlmaterialized-views
Tony
Tony

Reputation: 19151

Postgres materialized views or CREATE TABLE AS if not updating incrementally?

If I don't plan to implement incremental updates for materialized views in Postgres, are there any advantages to using them over CREATE TABLE AS? From what I have read, when you refresh a materialized view, that view locks and is not readable. Since it's unavailable, it seems to have the same affect as dropping and recreating a table at the same rate you run refresh on a materialized view.

Upvotes: 2

Views: 392

Answers (1)

elar1000
elar1000

Reputation: 41

As of PostgreSQL 9.3.2 you also cannot use materialized view data as basis of UPDATE query. So if you need to use this view as a basis of some updates then you are better of using regular tables.

Upvotes: 2

Related Questions