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