Re: update/delete and execution-time partition pruning - Mailing list pgsql-hackers

From David Rowley
Subject Re: update/delete and execution-time partition pruning
Date
Msg-id CAApHDvqhhQHrLBQdgyC=e3ykdf2rDp4a-KfyAO7MQHG59W-1rg@mail.gmail.com
Whole thread Raw
In response to update/delete and execution-time partition pruning  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: update/delete and execution-time partition pruning
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Andrey Lepikhov
Date:
Subject: Defer selection of asynchronous subplans until the executor initialization stage
Next
From: Peter Geoghegan
Date:
Subject: Re: PG 14 release notes, first draft