sayali k wrote: > As of now, PGSQL does not support materialized views. Just wanted to confirm > the difference between the materialized view and table. Is there some > operation which can be performed only on a table and not on a materialized > view or vice-versa?
That's quite an academic question, given that we really don't support materiealized views. Presumably updating materialized views would have the same limitations as normal views; only simple views are updatable, but you can create custom rules. Presumably physical level operations, like CREATE INDEX, CLUSTER and VACUUM would work on materialized views just like on tables. Is that the kind of operations you were thinking of? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
