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