Thread: update/delete and execution-time partition pruning

update/delete and execution-time partition pruning

From
Amit Langote
Date:
We apparently forgot in 86dc90056df to remove a note in 5.11.4.
Partition Pruning saying this:

   <note>
    <para>
     Execution-time partition pruning currently only occurs for the
     <literal>Append</literal> and <literal>MergeAppend</literal> node types.
     It is not yet implemented for the <literal>ModifyTable</literal> node
     type, but that is likely to be changed in a future release of
     <productname>PostgreSQL</productname>.
    </para>
   </note>

Now because we include the Append/MergeAppend node even if the query
is update/delete, this note is no longer useful or valid.

Attached patch removes that note.

-- 
Amit Langote
EDB: http://www.enterprisedb.com

Attachment

Re: update/delete and execution-time partition pruning

From
David Rowley
Date:
On Tue, 11 May 2021 at 15:36, Amit Langote <amitlangote09@gmail.com> wrote:
>
> We apparently forgot in 86dc90056df to remove a note in 5.11.4.
> Partition Pruning saying this:
>
>    <note>
>     <para>
>      Execution-time partition pruning currently only occurs for the
>      <literal>Append</literal> and <literal>MergeAppend</literal> node types.
>      It is not yet implemented for the <literal>ModifyTable</literal> node
>      type, but that is likely to be changed in a future release of
>      <productname>PostgreSQL</productname>.
>     </para>
>    </note>
>
> Now because we include the Append/MergeAppend node even if the query
> is update/delete, this note is no longer useful or valid.
>
> Attached patch removes that note.

Yeah. Agreed. That's out of date now.

I'll take care of this.

David



Re: update/delete and execution-time partition pruning

From
David Rowley
Date:
On Tue, 11 May 2021 at 15:46, David Rowley <dgrowleyml@gmail.com> wrote:
> I'll take care of this.

Pushed.

David



Re: update/delete and execution-time partition pruning

From
Amit Langote
Date:
On Tue, May 11, 2021 at 12:57 PM David Rowley <dgrowleyml@gmail.com> wrote:
>
> On Tue, 11 May 2021 at 15:46, David Rowley <dgrowleyml@gmail.com> wrote:
> > I'll take care of this.
>
> Pushed.

Thank you.

-- 
Amit Langote
EDB: http://www.enterprisedb.com