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)
Список
Дерево обсуждения
Support run-time partition pruning for hash join Richard Guo <guofenglinux@gmail.com>
Re: Support run-time partition pruning for hash join Andy Fan <zhihui.fan1213@gmail.com>
Re: Support run-time partition pruning for hash join David Rowley <dgrowleyml@gmail.com>
Re: Support run-time partition pruning for hash join Andy Fan <zhihui.fan1213@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 David Rowley <dgrowleyml@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 David Rowley <dgrowleyml@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 David Rowley <dgrowleyml@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 Richard Guo <guofenglinux@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 Alexander Lakhin <exclusion@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 Alexander Lakhin <exclusion@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 vignesh C <vignesh21@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 Richard Guo <guofenglinux@gmail.com>
Re: Support run-time partition pruning for hash join Andrei Lepikhov <lepihov@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 Andy Fan <zhihui.fan1213@gmail.com>
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 по дате отправления
От: Anthonin Bonnefoy
Дата: