| From: | "Hou, Zhijie" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com> |
|---|---|
| To: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
| Cc: | Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Luc Vlaming <luc(at)swarm64(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Zhihong Yu <zyu(at)yugabyte(dot)com> |
| Subject: | RE: Parallel Inserts in CREATE TABLE AS |
| Date: | 2020-12-21 02:46:11 |
| Message-ID: | 4d7a142737be4418a0fdcaac8db1ca43@G08CNEXMBPEKD05.g08.fujitsu.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hou, Zhijie | 2020-12-21 02:50:03 | RE: Parallel INSERT (INTO ... SELECT ...) |
| Previous Message | Stephen Frost | 2020-12-21 02:38:55 | Re: Proposed patch for key managment |