Content-Type: multipart/alternative;
 boundary="------------iWLOptNWIHywOveUbmTPUkRB"
Message-ID: <c1dcaa58-6b62-ddf3-1efc-fa56a50f8608@gmail.com>
Date: Mon, 6 Nov 2023 18:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: Support run-time partition pruning for hash join
Content-Language: en-US
To: Richard Guo <guofenglinux@gmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>, Andy Fan <zhihui.fan1213@gmail.com>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
References: <CAMbWs49atE64_JjqrF2+BBZvG-h7afL89wCghg_GmvOHPB_LbQ@mail.gmail.com>
 <CAKU4AWpGo7wXEQqvsv13s=Cto3k9QbucW5DJtjwD1a0dF9iTgA@mail.gmail.com>
 <CAApHDvp+O0PtZMWomyYg=RE68d1wBnc-yxjJsDK3hmYBnP=-qw@mail.gmail.com>
 <CAMbWs49+p6hBxXJHFiSwOtPCSkAHwhJj3hTpCR_pmMiUUVLZ1Q@mail.gmail.com>
 <CAApHDvrTwpgYG9UGjBJpMrey36LMpwtEx_2RWrByxSq7NnKqdA@mail.gmail.com>
 <CAMbWs488_uMqmyQo0Cq-XrDSiEqiXCnfJtCyhXrWn_HdBen3Tw@mail.gmail.com>
 <CAMbWs4_GhDa7+qRbdhLzMTXKZr2naiJc7C+tE1BcK5UVjxqncA@mail.gmail.com>
 <600a153e-191b-952d-7090-cad5097b798f@gmail.com>
 <CAMbWs49bPXs6SVFxJnV4zh_nH6AV0nhHRiJb+E+vFHy9xnvKCA@mail.gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: <CAMbWs49bPXs6SVFxJnV4zh_nH6AV0nhHRiJb+E+vFHy9xnvKCA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/c1dcaa58-6b62-ddf3-1efc-fa56a50f8608%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------iWLOptNWIHywOveUbmTPUkRB
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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
--------------iWLOptNWIHywOveUbmTPUkRB
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Hello Richard,<br>
      <br>
      06.11.2023 06:05, Richard Guo wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAMbWs49bPXs6SVFxJnV4zh_nH6AV0nhHRiJb+E+vFHy9xnvKCA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <br>
      <div dir="ltr">
        <div class="gmail_quote">
          <div>Fixed this issue in v4.<br>
            <br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    Please look at a warning and an assertion failure triggered by the<br>
    following script:<br>
    set parallel_setup_cost = 0;<br>
    set parallel_tuple_cost = 0;<br>
    set min_parallel_table_scan_size = '1kB';<br>
    <br>
    create table t1 (i int) partition by range (i);<br>
    create table t1_1 partition of t1 for values from (1) to (2);<br>
    create table t1_2 partition of t1 for values from (2) to (3);<br>
    insert into t1 values (1), (2);<br>
    <br>
    create table t2(i int);<br>
    insert into t2 values (1), (2);<br>
    analyze t1, t2;<br>
    <br>
    select * from t1 right join t2 on t1.i = t2.i;<br>
    <br>
    2023-11-06 14:11:37.398 UTC|law|regression|6548f419.392cf5|WARNING: 
    Join partition pruning $0 has not been performed yet.<br>
    TRAP: failed Assert("node-&gt;as_prune_state"), File:
    "nodeAppend.c", Line: 846, PID: 3747061<br>
    <br>
    Best regards,<br>
    Alexander<br>
  </body>
</html>

--------------iWLOptNWIHywOveUbmTPUkRB--