diff options
Diffstat (limited to 'src/test/regress/expected/jsonb_sqljson.out')
| -rw-r--r-- | src/test/regress/expected/jsonb_sqljson.out | 23 |
1 files changed, 15 insertions, 8 deletions
diff --git a/src/test/regress/expected/jsonb_sqljson.out b/src/test/regress/expected/jsonb_sqljson.out index 230cfd3bfd5..28338b4d193 100644 --- a/src/test/regress/expected/jsonb_sqljson.out +++ b/src/test/regress/expected/jsonb_sqljson.out @@ -2090,7 +2090,13 @@ LINE 1: SELECT * FROM JSON_TABLE(jsonb '{"a": 123}', '$' || '.' || '... -- Test parallel JSON_VALUE() CREATE UNLOGGED TABLE test_parallel_jsonb_value AS SELECT i::text::jsonb AS js -FROM generate_series(1, 500000) i; +FROM generate_series(1, 50000) i; +-- encourage use of parallel plans +set parallel_setup_cost=0; +set parallel_tuple_cost=0; +set min_parallel_table_scan_size=0; +set max_parallel_workers_per_gather=4; +set parallel_leader_participation = off; -- Should be non-parallel due to subtransactions EXPLAIN (COSTS OFF) SELECT sum(JSON_VALUE(js, '$' RETURNING numeric)) FROM test_parallel_jsonb_value; @@ -2101,9 +2107,9 @@ SELECT sum(JSON_VALUE(js, '$' RETURNING numeric)) FROM test_parallel_jsonb_value (2 rows) SELECT sum(JSON_VALUE(js, '$' RETURNING numeric)) FROM test_parallel_jsonb_value; - sum --------------- - 125000250000 + sum +------------ + 1250025000 (1 row) -- Should be parallel @@ -2113,14 +2119,15 @@ SELECT sum(JSON_VALUE(js, '$' RETURNING numeric ERROR ON ERROR)) FROM test_paral ------------------------------------------------------------------ Finalize Aggregate -> Gather - Workers Planned: 2 + Workers Planned: 4 -> Partial Aggregate -> Parallel Seq Scan on test_parallel_jsonb_value (5 rows) SELECT sum(JSON_VALUE(js, '$' RETURNING numeric ERROR ON ERROR)) FROM test_parallel_jsonb_value; - sum --------------- - 125000250000 + sum +------------ + 1250025000 (1 row) +DROP TABLE test_parallel_jsonb_value; |