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.94.2) (envelope-from ) id 1ujPHB-007Eez-0S for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Aug 2025 21:32:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ujPH9-00C0iF-DW for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Aug 2025 21:32:51 +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.94.2) (envelope-from ) id 1ujPH8-00C0i5-Gn for pgsql-hackers@lists.postgresql.org; Tue, 05 Aug 2025 21:32:51 +0000 Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ujPH5-000wSS-0G for pgsql-hackers@lists.postgresql.org; Tue, 05 Aug 2025 21:32:50 +0000 Received: from phl-compute-10.internal (phl-compute-10.phl.internal [10.202.2.50]) by mailfhigh.phl.internal (Postfix) with ESMTP id 09FE214000F7 for ; Tue, 5 Aug 2025 17:32:45 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Tue, 05 Aug 2025 17:32:45 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1754429565; x= 1754515965; bh=t0hATsixeiLkD6H/6ko+wJ5taYcb3I4aLY1CxFJ3l/w=; b=l j85F5ITYl93szioWUAD+9b+AkK5hJMgdn8qwj5QlmX3sC2c1WcZ95VSeKfdnsIVV h4+nMcyAlvadFgMlWrVU8BfduMPd/FRdV3opsZ6eFn44ojz18/DEaTmGehlI/K5E fP/RAlTJfmhW1rQNqasJvyrHRvrG6OHuBQwh981Z5WnCPuroAsk5uSD+u7Q7TrGZ TPCpNytGZzWxwF7QnlRCVjbNmIha9cRBDHxtCqhqAbClrcnbpYvUYfw2ps41NhOx k1cOv6143fRieFausyS/Qtw+TeIsbN7xa4B2128KLIp3lk7DQENY1Ii58mIjRwtz mJravBykuGQBVdU0pFJQA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to :subject:subject:to:to:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1754429565; x=1754515965; bh=t0hATsixeiLkD 6H/6ko+wJ5taYcb3I4aLY1CxFJ3l/w=; b=hnV/vQmWFus/PdInq6GmGTqksFU77 YQjrkjNPN9gSW+V0XGQ3xcnEalcpBn9A99AAcvUiCwASatufsQ9bpoCR/uxHEyfo BAIkWMTiOOlOC+vlupMf9LZ32aGumpuLop0f4jdqgmmF7jYYaeAcBsgf7zNSZtEi AohMnxfZogwluOVoPFNzrbInJzV+U/nhKyx/LnRHfdxCapG9DPLhIM+rAkBrwmrs 3sQ7wr/jRdtrjVTeSVY5TPfYvzEM42+Lea3APaqJcHn7ueltE5yYyIywJf0Z3LuT +Ykqz6NBGd+dawvMa70+94shp6LBF/PkW8nyiNq6N+lQIWtEXWC/LpTkQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdduudeivdeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvffukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnhepieduteegjeeuheffhfegveevudegtdektdefiefgkefgueffteehudev geetvdejnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghdpvghnthgvrhhprh hishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomheprghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtth hopedupdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgv rhhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA for ; Tue, 5 Aug 2025 17:32:44 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1754429561; bh=+ugt1ibYpGFMkd/4HflkLrwuI81VVQ/RR6Ff3Sp44rE=; h=Date:From:To:Subject:In-Reply-To:From; b=esI7Nc6BOmeYuafa8A7L/u4R+LTxM/uFFzX2IOfdyT02YD9ZW5sQBKDHKW7tW0HAU sphnKYeHugavOw9UrnC8zrmDhiQObkCJBezBbk+8KpZpxsMHKm0v6ZOB3TQKDdwFxP QlF6xnzrEplcnF8PW14DQsY/Irll6qEheMiVL/Z86fmaoKRGNWG+poYRN4xR6n66bl hkVoLtVo+DVidpLzxTA+/8CElUXPC88LH7hio3CpyHvdgLUsDSXc/8VNulTazkofrW rxmdAARcRQ6VAdbB7Rq9pJc2OwUd4JaUcQbW9ifGByQpoUgNHaaYXnaGth5sZpvixq bpUOj5oX5pzwQ== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id A7DB790; Tue, 5 Aug 2025 23:32:41 +0200 (CEST) Date: Tue, 5 Aug 2025 23:32:41 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: PostgreSQL Hackers Subject: Re: Function scan FDW pushdown Message-ID: <202508052132.3g3ytrc74bge@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, On 2024-Nov-05, g.kashkin@postgrespro.ru wrote: > This is a long-overdue follow-up to the original patch. > Note that this patch contains only the changes required for > function scan pushdown, examples and code related to asymmetric > join are dropped. I've marked this as returned with feedback, as several months have passed without a further version; the current one has a number of gotchas, including some problematic coding detected by a compiler warning, as well as unfinished design: > The issue with setting newrte->functions to NIL still persists. > [...] > I am aware that the rte->functions will now be copied even on > instances that don't utilize a FDW, but I don't see a way to solve it. > Any suggestions are welcome. Feel free to reopen this CF entry[1] once you're able to figure this out. [1] https://commitfest.postgresql.org/patch/5470/ -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/