Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1o8maI-0002Lr-07
	for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Jul 2022 17:43:38 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1o8maG-0004hg-SN
	for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Jul 2022 17:43:36 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <jchampion@timescale.com>)
	id 1o8maG-0004hW-Hb
	for pgsql-hackers@lists.postgresql.org; Tue, 05 Jul 2022 17:43:36 +0000
Received: from mail-oi1-x22b.google.com ([2607:f8b0:4864:20::22b])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <jchampion@timescale.com>)
	id 1o8maE-0005Ts-Jr
	for pgsql-hackers@postgresql.org; Tue, 05 Jul 2022 17:43:36 +0000
Received: by mail-oi1-x22b.google.com with SMTP id s188so16805326oib.6
        for <pgsql-hackers@postgresql.org>;
 Tue, 05 Jul 2022 10:43:34 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=timescale.com; s=google;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=EV8vDMrfYdueCpLMPbAgLwPzUuLn0m9zRRdUZduPM94=;
        b=KsfGGR5/pmlurrHxjpS5am+ksLraSlc9BZ1UUC4t0HgDUW9nhOLENegO+FAg0aDK4n
         IrsVmxTWQO/BJ0XnErkw8DTeLslre26AfD/T/kFImaDNFFtzPw1KeQA/w0n+Q2Ob80Ah
         RuPgYDY6Hx7ZIpg6Am8iFT6J/BMX81NlDMyQD4ehqdD0BYDiXKxrU1vdgZ7pzeOkb9md
         SWrHtEESUEPI4m5V0T5JeXehBs7DWD278N9SQlXwCNYsxqAfuiiXAeJ6LHUIWJD27+8J
         SKEeg+Lo9pP+PcaEyCR4Y7T4bHVB2XysWwxfUxUNoh+s/nGwggOZuyoUV3EPpK4GPl8d
         zoEQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=EV8vDMrfYdueCpLMPbAgLwPzUuLn0m9zRRdUZduPM94=;
        b=gi7cvnhA7cDd186Pz4o2x1NY7sboP5uKQRtxw31Ojp4UVCBssaNesZiWhZ5honkzxk
         SqkFShpvzjiJzaopICx0JUrTwEnR5F1LGQgAPEqkaXZxcBtZrgN+/UkZ4S2Yqe9Z+do0
         SAkWorjPWW3Lah4F5hFfhem5m0IKdIgJ/HA4AKPHMLpIR3wXMASR77aY6KckAjqWtJOX
         eWSlJK3vwgcOCVHc+LeeBMFnHC9xayjPbbtI22YPpc4LL7InleCPjooQGw9SMiYARFxe
         ODEiQSuBCs29w/VVxovnWiAkE8i7dfsgO+tBsmmihaRAHaCXJRXm+d+daf0Sp/+9Sgfr
         AR7g==
X-Gm-Message-State: AJIora8u8jvPc2vP6XfsKPjdLTDxIMH6AN+dI0edRXeoKek4BWzixZE3
	4wtfU+7D7g2Elgj1d8+KmNYtWYkW+9omrusrWrGEFA==
X-Google-Smtp-Source: 
 AGRyM1sr9FmrmIqpWin32JAW5kJN4f7QN+3EetE/qv+jrPfkEiCMUA0rTB7F4h8dvQFzP4eT6gHZDzbCzfU9dM4aF7I=
X-Received: by 2002:a05:6808:f8d:b0:335:6ee0:cd2c with SMTP id
 o13-20020a0568080f8d00b003356ee0cd2cmr20015993oiw.285.1657043012425; Tue, 05
 Jul 2022 10:43:32 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CA+HiwqFGkMSge6TgC9KQzde0ohpAycLQuV7ooitEEpbKB0O_mg@mail.gmail.com>
 <CA+TgmoZ=92LxPeVJ20vf4vJ4o8dr7Q2seDQR=xLY04puLjDs_A@mail.gmail.com>
 <CA+HiwqEAdv+1t+v6pkcH9pgsSXnBeHLchDuGRwXP-oEB4BCPmg@mail.gmail.com>
 <CA+TgmobN=+AoDE4JZioVpaRXJVCQ2Fa9Uw3TjC-OqnXWQ0uq1w@mail.gmail.com>
 <CA+HiwqFOsJ21nmvoKtPkzxKfYzACajj-mAOoJ+-y_O6g+-v-aA@mail.gmail.com>
 <CA+TgmoanT5K44bHZqMXxjAKwyF7nhajKBrw-p-+HSyEzOVqX1w@mail.gmail.com>
 <CA+HiwqGbnNGttKr8fK2pAYcC1JAapo=1nXO7OQs2M7+HmoVVpw@mail.gmail.com>
 <CA+HiwqEYCpEqh2LMDOp9mT+4-QoVe8HgFMKBjntEMCTZLpcCCA@mail.gmail.com>
 <CA+TgmoYbpAC4fDWLBSg6MZ9SymyKrt3NSc42whin9Qbgm71nCQ@mail.gmail.com>
 <215356.1647286703@sss.pgh.pa.us>
 <CA+Tgmoakey5yO+TTp0Gntz5MdnMLhd+Ei-+HWuCszHJeVU_YVA@mail.gmail.com>
 <CA+HiwqEDuz6OaM0Rv2D6kXgK0Cusr7HtquZTPjan+U76AJm0pg@mail.gmail.com>
 <CA+HiwqH9-fAvpG-w9qYCcDWzK3vGPCMyw4f9nHzqkxXVuD1pxw@mail.gmail.com>
 <CA+HiwqFq9UQiSJbGpJkmd0MkxqQLZWGk1+__tyk0QM+hmYHrrA@mail.gmail.com>
 <CA+HiwqERQkaKkE8TwNmFP2SDBykttAqBkwh_Niif9FqST7F4Kg@mail.gmail.com>
 <CA+HiwqGoORM+yfm8PhGWfHNUSBbSUgTQC=s5ieV8b4FX1yDBrg@mail.gmail.com>
 <CAApHDvp_DjVVkgSV24+UF7p_yKWeepgoo+W2SWLLhNmjwHTVYQ@mail.gmail.com>
 <CA+HiwqH7pYXfPZhHCKTmb_=C0z538wP8Mog+_j+vTi7JCVqnhQ@mail.gmail.com>
 <CAApHDvrpWWtSRZXFO31H1KcC9csKuE31v2f7k6rVS9Yp5ibc7Q@mail.gmail.com>
 <CA+HiwqEhn35nnFqv-0-T8mO1=ug7VcU2_3LnnToT2PzCNw9+4w@mail.gmail.com>
 <CAApHDvqno9XyXr9aXyWOKQ96-fzdyh5dRZbbzTQopYNq1CNJCQ@mail.gmail.com>
 <CA+HiwqEn-xV1B-QwxeTMs52MzGjaQFS24jiE-1LvMViHLNNfhg@mail.gmail.com>
 <CA+HiwqEUEoAPX+UH0nM+pyA_-hXEH3oWdoBPEfD_uaR6GGu8nA@mail.gmail.com>
 <CA+HiwqH4qQ_YVROr7TY0jSCuGn0oHhH79_DswOdXWN5UnMCBtQ@mail.gmail.com>
 <CAApHDvroRU6wZC-Ruo5jQjEWOgcdey=gU0jwp-W2_S6DUVR8Bg@mail.gmail.com>
 <CA+HiwqE_AV1PAyVeHez89zo7CgH=4dSMBOKi0Rgxt81xEqH9QQ@mail.gmail.com>
 <CAApHDvrkj0VVeXkZZF5cQ4i8GwN3fYrVUs0RiFm8=k7JU8Rruw@mail.gmail.com>
 <CA+HiwqH5gy3FquH1N+mqfU-b0wAZ97Sgeb0maYa0ZQxE6K=vGA@mail.gmail.com>
 <CA+HiwqFSxKsqWr3Cs3qkt3ngRD0fABshiFTcVEm8RstytycfEw@mail.gmail.com>
 <CALNJ-vStLKDVRB986gd_SHx9e8Oi86WYR5xZdtoSJ9zs5rfFQA@mail.gmail.com>
 <CA+HiwqHx22zGr9daNkihvUNFWfGoqjkKfE+otaeQ+Gy9gyYjLg@mail.gmail.com>
In-Reply-To: 
 <CA+HiwqHx22zGr9daNkihvUNFWfGoqjkKfE+otaeQ+Gy9gyYjLg@mail.gmail.com>
From: Jacob Champion <jchampion@timescale.com>
Date: Tue, 5 Jul 2022 10:43:21 -0700
Message-ID: 
 <CAAWbhmib2bKApH+CLFD-fscknSP24-8kZcqOZ5++MpD1Eccg=g@mail.gmail.com>
Subject: Re: generic plans and "initial" pruning
To: Amit Langote <amitlangote09@gmail.com>
Cc: Zhihong Yu <zyu@yugabyte.com>, David Rowley <dgrowleyml@gmail.com>,
	Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CAAWbhmib2bKApH%2BCLFD-fscknSP24-8kZcqOZ5%2B%2BMpD1Eccg%3Dg%40mail.gmail.com>
Precedence: bulk

On Fri, May 27, 2022 at 1:09 AM Amit Langote <amitlangote09@gmail.com> wrote:
> 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".

This patchset will need to be rebased over 835d476fd21; looks like
just a cosmetic change.

--Jacob