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  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-hackers
Hello Richard,

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 по дате отправления:

Предыдущее
От: Alexander Kukushkin
Дата:
Сообщение: Re: pg_rewind WAL segments deletion pitfall
Следующее
От: Anthonin Bonnefoy
Дата:
Сообщение: Re: POC: Extension for adding distributed tracing - pg_tracing