Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGqAp-00000002doe-1gQu for pgsql-hackers@arkaria.postgresql.org; Wed, 14 Oct 2026 04:01:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xGqAn-00000000AZG-0qh9 for pgsql-hackers@arkaria.postgresql.org; Wed, 14 Oct 2026 04:01:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGqAm-00000000AZ7-3Ye5 for pgsql-hackers@lists.postgresql.org; Wed, 14 Oct 2026 04:01:00 +0000 Received: from mail-dy1-x1330.google.com ([2607:f8b0:4864:20::1330]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xGqAk-00000001zMf-2Kwk for pgsql-hackers@lists.postgresql.org; Wed, 14 Oct 2026 04:01:00 +0000 Received: by mail-dy1-x1330.google.com with SMTP id 5a478bee46e88-35179d0747fso272233eec.1 for ; Tue, 13 Oct 2026 21:00:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1791950456; x=1792555256; darn=lists.postgresql.org; h=mime-version:content-transfer-encoding:content-type:references :in-reply-to:message-id:date:subject:cc:to:from:from:to:cc:subject :date:message-id:reply-to:content-type; bh=DIPfykoXKooNuf/uQMb83jwfrsEW0v/yBMVFP2scl3Q=; b=J0Y7PzWXowJMP7FqlSMKO6U5bTbWiwIlljxJSWjy0PMLcRFin1qTZBlFaIPGiTp4GP 7h7yPyxz8bjMkhKGswlIy2FfIgKjY/2MCJdhDN06lBKLRInh41bYhgmf9hlrWrF6tfCu eusTnPzcQm1zgC9Qg0bO/Hbhlq7GTA7hjyLrqfWMtO8LvC2arxRp0e+OOTQAuDHjLOvq RGK5+QVfCyKwfewL35W/5PakZkggrr2WHobWvKZ0U0QVN/3imenXrP4Zc0ScP+DcBrBb epDRgzUeEUzq2Xdkd3FDHvRiTM/M7ML8teTvOkep9SsNaOjeCezCgvW0tostRRF6V2Vi 2rBg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1791950456; x=1792555256; h=mime-version:content-transfer-encoding:content-type:references :in-reply-to:message-id:date:subject:cc:to:from:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=DIPfykoXKooNuf/uQMb83jwfrsEW0v/yBMVFP2scl3Q=; b=BdO3qF6JC8PmhmzJqPorakQkx2l+3DEXDStaYMhpjtCYpF+YLPkQifU3C0i9UfC/Jm X4oZxl14iIQ7UYHK6YDIhLbU7g7oRiMlWrF/W2uB29KnAP+/m+np0gjHqcpxho1M4Y5W u+1bZkjlg7xnXw0PhpxKjSWoK9tYsEh1VjKpf2xNisdtHV/U41IThjg2gJYQgYvPWUS2 y/4aAig5KdHGQ7APrL2Bh6BsQa8tFs1iyw3P8Ua9tuYPLf08H72Lq8+sDDj1kEV6gXCW S40Ti7e477PB92ILilx5PxGMS/sioXbPPxQOYzrL6CRMFfv3Yc3oucC8r5RmqhOyh1Y+ e2nQ== X-Forwarded-Encrypted: i=1; AKwUvBwLYx5MEcXmso5jesdH/ethx5NBR/ZMtzmHO/sY2oBQ+2LyiDiKMamphXSKDGspVTX3CGCUKTupErRl3/pn@lists.postgresql.org X-Gm-Message-State: AFq9FYKMorJYEAs38BvXDfb6yZwpDFy7IoaNQWL9vBokE4dRurZiTX6f vF+j90PJHP8HmgUQc/2o9Bfjoe/R8Nv3hXJDqZd7egQSIxaPyVrb6iVS X-Gm-Gg: AYBFou31Bd3MOxEN/R+L039IHr6Th7qf3q4M3T5olfYlIJ6Kx+lhoTFing9JNcRe1Mm K027hIORqph/8K34KUHiZnHav872dc5vT/TrsQzehQVTH48L5I8s6LbfBp4L0i+ff1VtDlzAMBX uitqoNf5dI/682sd+T/mNyhBP+ub3vmItHF7Bf+bmxvf2SvnOFROXPK8wT4aTsk5OnT28UztY+R EONFzEtDB8LvIzMrXJkhkEesDN+3jTF9gRDfKK5+xQS0ypFP7QTRqzMl4zE32Sd8hGGRzTwnPpG CWDOG+KlaBbiFZUeyW5l3/WpEAE1wlUfjySfHqN39AtumZ4bKT/nOQSAghL62nkIpVmofsRkoJR GgwWE2/eoKtDoFyERvtndXmSouOWT/3g3RIN9DYC+t1z5nCNzvuqqEds5CBgYeXQMkRb8eVeNEZ oVNsHcDiBZNbavsHN51KyFqozxGnbJ+HvXsXxoOgmTC38WW+9fIXtnOl2g4bYuzBuy9NlOvzQzQ nCPBjJtOxIO1HOUi9Yc7pkNPC4hG8vPXzJvsnfQgS840nmI5Q9kSZlUTzyk8jhKOkh1m7X8ScE9 Gs5kY3bSLhfVZquoJ7Su+w== X-Received: by 2002:a05:693c:6215:b0:35b:cb8a:8ce7 with SMTP id 5a478bee46e88-35bcb8a919dmr12093110eec.1.1791950455635; Tue, 13 Oct 2026 21:00:55 -0700 (PDT) Received: from 192.168.1.109 ([190.12.171.25]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-35977229a6esm33068158eec.8.2026.10.13.21.00.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 13 Oct 2026 21:00:55 -0700 (PDT) From: Manu To: Rui Zhao Cc: Amit Langote , Ilmar Yunusov , pgsql-hackers@lists.postgresql.org Subject: Re: generic plans and "initial" pruning Date: Wed, 14 Oct 2026 00:59:52 -0300 Message-ID: <179195039214.451044.8981055808666834441@gmail.com> In-Reply-To: References: Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Rui, > I've combined Manu's correction and the test in the attached patch, > which applies on top of v13. Thanks for folding in the test -- it fails on v13 without the ownership correction and passes with it, the same as I saw. cfbot is red only because v13 itself needs a rebase: 1b5dd3a24a4 added an early return in InitExecPartitionPruneContexts() that conflicts with v13-0002. The resolution is mechanical -- the lines v13-0002 adds and removes are unchanged, only the surrounding context moved, and the patch-ids of v13-0001/0003/0004 and your 0001 are identical before and after. On a v13 rebased that way on today's master (0d6103e537e1) with your 0001 on top: make check 239/239, isolation 134/134 and test_plan_advice all pass. Without the ownership fix, make check fails one test with "plancache reference ... is not owned by resource owner Portal", so the fix is still doing its job on current master. I'm happy to post the rebased series if that's useful; otherwise it's a one-liner of context for whoever rebases v13. Regards, Manu