Category "materialized-views"

Query against a materialized view with uniqExact column fails due to memory limit

I have a materialized view with the following structure: CREATE MATERIALIZED VIEW events_daily ENGINE = AggregatingMergeTree() ORDER BY ( owner_

Listing tables USED BY materialized view in PostgreSQL?

I've googled for it, both couldn't find an answer. How can I list tables used by materialized view (must not use the information_schema views) in PostgreSQL? Th

ORA-12015: cannot create a fast refresh materialized view from a complex query

I am using below query to build a materialized view. CREATE MATERIALIZED VIEW gcms_business_profile_mview BUILD IMMEDIATE REFRESH FAST WITH PRIM