1--
2-- PARALLEL
3--
4
5begin;
6
7-- encourage use of parallel plans
8set parallel_setup_cost=0;
9set parallel_tuple_cost=0;
10set min_parallel_table_scan_size=0;
11set max_parallel_workers_per_gather=4;
12
13--
14-- Test write operations that has an underlying query that is eligible
15-- for parallel plans
16--
17explain (costs off) create table parallel_write as
18    select length(stringu1) from tenk1 group by length(stringu1);
19create table parallel_write as
20    select length(stringu1) from tenk1 group by length(stringu1);
21drop table parallel_write;
22
23explain (costs off) select length(stringu1) into parallel_write
24    from tenk1 group by length(stringu1);
25select length(stringu1) into parallel_write
26    from tenk1 group by length(stringu1);
27drop table parallel_write;
28
29explain (costs off) create materialized view parallel_mat_view as
30    select length(stringu1) from tenk1 group by length(stringu1);
31create materialized view parallel_mat_view as
32    select length(stringu1) from tenk1 group by length(stringu1);
33create unique index on parallel_mat_view(length);
34refresh materialized view parallel_mat_view;
35refresh materialized view concurrently parallel_mat_view;
36drop materialized view parallel_mat_view;
37
38prepare prep_stmt as select length(stringu1) from tenk1 group by length(stringu1);
39explain (costs off) create table parallel_write as execute prep_stmt;
40create table parallel_write as execute prep_stmt;
41drop table parallel_write;
42
43rollback;
44