Re: update/delete and execution-time partition pruning

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: update/delete and execution-time partition pruning
Дата
Msg-id CAApHDvqhhQHrLBQdgyC=e3ykdf2rDp4a-KfyAO7MQHG59W-1rg@mail.gmail.com
обсуждение исходный текст
Ответ на update/delete and execution-time partition pruning  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: update/delete and execution-time partition pruning
Список 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 по дате отправления:

Предыдущее
От: Andrey Lepikhov
Дата:
Сообщение: Defer selection of asynchronous subplans until the executor initialization stage
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: PG 14 release notes, first draft