update/delete and execution-time partition pruning

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: update/delete and execution-time partition pruning
Date: 2021-05-11 03:35:36
Message-ID: CA+HiwqFxQn7Hz1wT+wYgnf_9SK0c4BwOOwFFT8jcSZwJrd8HEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 Content-Type Size
update-delete-exec-pruning-doc.patch application/octet-stream 831 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira 2021-05-11 03:38:39 Re: Corrected documentation of data type for the logical replication message formats.
Previous Message Andres Freund 2021-05-11 02:59:40 Re: walreceiver that is behind doesn't quit, send replies