Hi, I got a server crash with partition_wise_join, steps to reproduce given below.
postgres=# set enable_partition_wise_join=true; SET postgres=# CREATE TABLE tbl (a int,c text) PARTITION BY LIST(a); CREATE TABLE postgres=# CREATE TABLE tbl_p1 PARTITION OF tbl FOR VALUES IN (1, 2); CREATE TABLE postgres=# CREATE TABLE tbl_p2 PARTITION OF tbl FOR VALUES IN (3, 4); CREATE TABLE postgres=# INSERT INTO tbl VALUES (1,'P1'),(2,'P1'),(3,'P2'),(4,'P2'); INSERT 0 4 postgres=# EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM tbl t1 INNER JOIN tbl t2 ON (t1.a = t2.a) WHERE t1.c = 'P1' AND t1.c = 'P2'; NOTICE: join between relations (b 1) and (b 2) is considered for partition-wise join. server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !> Thanks & Regards, Rajkumar Raghuwanshi QMG, EnterpriseDB Corporation