Re: generic plans and "initial" pruning

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Zhihong Yu <zyu(at)yugabyte(dot)com>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: generic plans and "initial" pruning
Date: 2022-05-27 08:09:46
Message-ID: CA+HiwqHx22zGr9daNkihvUNFWfGoqjkKfE+otaeQ+Gy9gyYjLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Apr 11, 2022 at 12:53 PM Zhihong Yu <zyu(at)yugabyte(dot)com> wrote:
> On Sun, Apr 10, 2022 at 8:05 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
>> Sending v15 that fixes that to keep the cfbot green for now.
>
> Hi,
>
> + /* RT index of the partitione table. */
>
> partitione -> partitioned

Thanks, fixed.

Also, I broke this into patches:

0001 contains the mechanical changes of moving PartitionPruneInfo out
of Append/MergeAppend into a list in PlannedStmt.

0002 is the main patch to "Optimize AcquireExecutorLocks() by locking
only unpruned partitions".

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

Attachment Content-Type Size
v16-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch application/octet-stream 21.2 KB
v16-0002-Optimize-AcquireExecutorLocks-by-locking-only-un.patch application/octet-stream 87.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2022-05-27 08:11:15 Re: enable/disable broken for statement triggers on partitioned tables
Previous Message houzj.fnst@fujitsu.com 2022-05-27 07:34:32 RE: bogus: logical replication rows/cols combinations