I am wondering whether CREATE
(with data) or REFRESH MATERIALIZED VIEW
uses the parallel planner? When I EXPLAIN ANALYZE
the query by itself (any query with parallel potential works here) without creating the materialized view, it shows that said query is parallel aware, and executing said query by itself shows multiple processors active using standard linux tools like top. Conversely, executing the query within a REFRESH
or CREATE
materialized view wrapper, does not show multiple processes, and using EXPLAIN
on CREATE MATERIALIZED VIEW
shows a query that is not parallel aware. Is this the intentional behavior and why? I was not able to find any information on this.
Does CREATE/REFRESH MATERIALIZED VIEW in PostgreSQL use the parallel planner?
Floris
- 121
- 4