Postgres Pro
Downloads
Home   >   mailing lists

RE: Parallel Inserts in CREATE TABLE AS - Mailing list pgsql-hackers

From Hou, Zhijie
Subject RE: Parallel Inserts in CREATE TABLE AS
Date
Msg-id 4d7a142737be4418a0fdcaac8db1ca43@G08CNEXMBPEKD05.g08.fujitsu.local
Whole thread Raw
In response to Re: Parallel Inserts in CREATE TABLE AS  (Dilip Kumar <dilipbalaut@gmail.com>)
Responses Re: Parallel Inserts in CREATE TABLE AS
List pgsql-hackers
Tree view 
Hi

The cfbost seems complains about the testcase:

Command exited with code 1
perl dumpregr.pl
=== $path ===\ndiff -w -U3 C:/projects/postgresql/src/test/regress/expected/write_parallel.out
C:/projects/postgresql/src/test/regress/results/write_parallel.out
--- C:/projects/postgresql/src/test/regress/expected/write_parallel.out    2020-12-21 01:41:17.745091500 +0000
+++ C:/projects/postgresql/src/test/regress/results/write_parallel.out    2020-12-21 01:47:20.375514800 +0000
@@ -1204,7 +1204,7 @@
                ->  Gather (actual rows=2 loops=1)
                      Workers Planned: 3
                      Workers Launched: 3
-                     ->  Parallel Seq Scan on temp2 (actual rows=0 loops=4)
+                     ->  Parallel Seq Scan on temp2 (actual rows=1 loops=4)
                            Filter: (col2 < 3)
                            Rows Removed by Filter: 1
(14 rows)
@@ -1233,7 +1233,7 @@
                ->  Gather (actual rows=2 loops=1)
                      Workers Planned: 3
                      Workers Launched: 3
-                     ->  Parallel Seq Scan on temp2 (actual rows=0 loops=4)
+                     ->  Parallel Seq Scan on temp2 (actual rows=1 loops=4)
                            Filter: (col2 < 3)
                            Rows Removed by Filter: 1
(14 rows)

Best regards,
houzj

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Proposed patch for key managment
Next
From: "Hou, Zhijie"
Date:
Subject: RE: Parallel INSERT (INTO ... SELECT ...)