Thread: update/delete and execution-time partition pruning
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
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
On Tue, 11 May 2021 at 15:46, David Rowley <dgrowleyml@gmail.com> wrote: > I'll take care of this. Pushed. David
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