15670430创建于 2020年12月28日历史提交
\! echo "" >@abs_srcdir@/gsql_parallel.sql
\! echo "drop table if exists test_tmp;" >>@abs_srcdir@/gsql_parallel.sql
\! echo "create temp table test_tmp (id bigint) with (orientation = column);" >>@abs_srcdir@/gsql_parallel.sql
\! echo "\parallel on 2" >>@abs_srcdir@/gsql_parallel.sql
\! echo "insert into test_tmp values (generate_series(1,20));" >>@abs_srcdir@/gsql_parallel.sql
\! echo "insert into test_tmp values (generate_series(1,20));" >>@abs_srcdir@/gsql_parallel.sql
\! echo "insert into test_tmp values (generate_series(1,20));" >>@abs_srcdir@/gsql_parallel.sql
\! echo "insert into test_tmp values (generate_series(1,20));" >>@abs_srcdir@/gsql_parallel.sql
\! echo "insert into test_tmp values (generate_series(1,20));" >>@abs_srcdir@/gsql_parallel.sql
\! echo "insert into test_tmp values (generate_series(1,20));" >>@abs_srcdir@/gsql_parallel.sql
\! echo "\parallel off" >>@abs_srcdir@/gsql_parallel.sql
\! echo "select count(*) from test_tmp;" >>@abs_srcdir@/gsql_parallel.sql
\! @abs_bindir@/gsql -r -p @portstring@ -d regression -f @abs_srcdir@/gsql_parallel.sql
--?
DROP TABLE
CREATE TABLE
Parallel is on with scale 2.
Parallel is off.
SET
INSERT 0 20
INSERT 0 20
INSERT 0 20
INSERT 0 20
INSERT 0 20
INSERT 0 20
 count 
-------
   120
(1 row)

--?
\! @abs_bindir@/gsql -r -p @portstring@ -d regression -f @abs_srcdir@/gsql_parallel.sql
--?
DROP TABLE
CREATE TABLE
Parallel is on with scale 2.
Parallel is off.
SET
INSERT 0 20
INSERT 0 20
INSERT 0 20
INSERT 0 20
INSERT 0 20
INSERT 0 20
 count 
-------
   120
(1 row)

--?
\! rm @abs_srcdir@/gsql_parallel.sql