From: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
---|---|
To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
Cc: | David Rowley <dgrowleyml(at)gmail(dot)com>, Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Support run-time partition pruning for hash join |
Date: | 2023-11-06 15:00:00 |
Message-ID: | c1dcaa58-6b62-ddf3-1efc-fa56a50f8608@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Anthonin Bonnefoy | 2023-11-06 15:08:49 | Re: POC: Extension for adding distributed tracing - pg_tracing |
Previous Message | Alexander Kukushkin | 2023-11-06 14:58:56 | Re: pg_rewind WAL segments deletion pitfall |