Re: Support run-time partition pruning for hash join
От | Alexander Lakhin |
---|---|
Тема | Re: Support run-time partition pruning for hash join |
Дата | |
Msg-id | c1dcaa58-6b62-ddf3-1efc-fa56a50f8608@gmail.com обсуждение исходный текст |
Ответ на | Re: Support run-time partition pruning for hash join (Richard Guo <guofenglinux@gmail.com>) |
Ответы |
Re: Support run-time partition pruning for hash join
|
Список | pgsql-hackers |
Hello Richard,
06.11.2023 06:05, Richard Guo wrote:
06.11.2023 06:05, Richard Guo wrote:
Fixed this issue in v4.
Please look at a warning and an assertion failure triggered by the
following script:
set parallel_setup_cost = 0;
set parallel_tuple_cost = 0;
set min_parallel_table_scan_size = '1kB';
create table t1 (i int) partition by range (i);
create table t1_1 partition of t1 for values from (1) to (2);
create table t1_2 partition of t1 for values from (2) to (3);
insert into t1 values (1), (2);
create table t2(i int);
insert into t2 values (1), (2);
analyze t1, t2;
select * from t1 right join t2 on t1.i = t2.i;
2023-11-06 14:11:37.398 UTC|law|regression|6548f419.392cf5|WARNING: Join partition pruning $0 has not been performed yet.
TRAP: failed Assert("node->as_prune_state"), File: "nodeAppend.c", Line: 846, PID: 3747061
Best regards,
Alexander
В списке pgsql-hackers по дате отправления: