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 1txY57-00B2ns-2M for pgsql-general@arkaria.postgresql.org; Wed, 26 Mar 2025 21:14:37 +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 1txY55-00AXXe-Bj for pgsql-general@arkaria.postgresql.org; Wed, 26 Mar 2025 21:14:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1txY54-00AXPT-Hj for pgsql-general@lists.postgresql.org; Wed, 26 Mar 2025 21:14:34 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1txY52-001JCX-0M for pgsql-general@lists.postgresql.org; Wed, 26 Mar 2025 21:14:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1743023670; x=1743628470; i=karsten.hilbert@gmx.net; bh=AGY8tNBaLyNLTnQrM55kbe7Ut6Th4aTxIam3Um47uNw=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=qidCih10mXsse6+VQV4+XZE5J6vxY35qbu59KBI9Jg7CEe7Xi5kepB5iuwEBoKkz k9dSjW/x0nkVq4NLfXk3B0uoCHhP9oq0iDFGj5URaPJtV/cZvoe05W1wVD82nBXmO p9biWGM/4YIm0dwk3SOr93n0FTPH3Xb1QCV63/AQXEzdVKPGp5UHOj/4DGGYHcRZp 3AKY8YUjj8H5x3HUlUg7v0aXdp8c7txrho2YF0sOX2SZ+FqAqgkoBin/78VC5yuEG K4QbfnhYiUXvGf5xM0q6jQvFxIP04wz6he7ukoR7SyqmRNpC6LPlJcdcuB1Roa2Yk rlpGYZATsgnQdsCa/A== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.190.228.50]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MbivG-1tQ7js0EM2-00pU0j; Wed, 26 Mar 2025 22:14:30 +0100 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1txY4z-0004kx-1I; Wed, 26 Mar 2025 22:14:29 +0100 Date: Wed, 26 Mar 2025 22:14:29 +0100 From: Karsten Hilbert To: Tom Lane Cc: pgsql-general@lists.postgresql.org Subject: Re: Q on SELECT column list pushdown from view to table Message-ID: References: <1321213.1742943334@sss.pgh.pa.us> <1776634.1743021415@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1776634.1743021415@sss.pgh.pa.us> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:bxTf20YeYIReVH6FyIFaFJh/8GQ0CHoq8yOMQuyXSNDlH2pYt7R VxuTfK5Mjm6mdLhbSkZril3dI5T+bU1w2LI1isItizlneLDhZgLlk1rR/Fu1SIYG9XB8GGU 1C9/vYue6v6QpaZOC6lmkvzsPSxlgfxaCz2ZU9it9wtjLS3a4k/RVt4vdGYPLzT2he1w1yY Ak6FU2A/Zlo0gx+JWwr5A== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:UyNWgrIH2NA=;W6hT3vsbp4NiDNc2mYNZQdqnRNI GXIvRWDzBPDz4dbmEtCcV8rtP5crCKFHUm4TL7lDyPG8HIRyqv2kNnwweFxIgJxy5O91LIjQO 02b6pUI0RnXf2fo+cFnpgUDuYAOuzN1WURNSsOt4YiZzLszqf0hEHunzi1ntwmoajx6OgqXm3 EyxAahXzxCMh+Tk+KMWg2mO1+Cy40JLeyBmUAnUrqjHsTMoGiy291dCcQehIaiAGmh7SX4yHf FDv/JToJ3MMju2+Ogt1qIo8mlftdlFDfqfL2zX1Mfgih/gOAHhgEy+I0jeVIjNthueZVW05Vu 1awU853BsGu/qYq6zwCwJ10jZn5iluJxD+XMtCCo3i8FYb0sZo5BQgIgph3DDvepe+WS4OiQ+ 52kNtPWVEDAjHDbusgib/gw1E7wTQD4KiWmhH5wmbkqpn4zcXk5l5A/Vykic4mslNYweygtes bL0iZ2rwl13Z5TaO7RRd8ZCZbUjPbKG0VBjWB8986/tfyiuUW6FUm/kPec9zV8hv4GWq9ZORz fFAJOkgFf9VOF1JhZgVgoxzoUPwfsELctiJtvIlT4CJfnCVrA9ffOG+XZZZiG4Bi5JAQfC2Y1 qbcZUmqa2+LindgEFDIGoCKtqxH3r07t0KXT5AyggK99qAQLHfHdzHIs4TiVN40bZuCxPVwLu xxK3dva3/dBAQzZHdSxqF5K3JTXANwME37if0HeAvsptSxBdGiA+4gwUoCfFrCxnCKLcevuFP pfH/yLoRO/+hNXyHHM+zDWsmQ6MOf/gwOalMP7edWW1soNvNZo+H9Yd5oUMl1wPz+k7NKWMGJ 3+WhdH4CzxLuTPGRJ7RCyWyNJEkQSNBMKLMkhRMvliqbRuPPrFUgVB3hQesWDjGx+G0X04jex 64kXyfhd0ACX9FmVXwpCw4wl/bWAvh/EBMoLC0YS5dZPwXao1oAXqayWlSdL5Osg5U+5XHa3g kXnhTFAY+z2Lw2i+0WTllQywByCDJlkWHYfw4utnsF5d94SUENeedu2SzWzkB/UJE9UHvJvtb EDT73tTm4V5WIWtq5e6ES0NdQzCz24dr2AkaD4aBGRMn/bH4RFtXlClzp15LwD8VQH0TMoyxo aDLL9z+af+x0Hig2qhaemKFuw9zjd+EpmUvyF+qsiiTrEVbb/8xss4O9s4cEwq9F/lP2kD35h EVBcqVk2TrsfnI4V408Xk9WPOm191I92B4V4tz96w6u+tI5pRG8DSxsOR/mzx/TsPEGTVcbdo Y/9yvM+YQPuU/cEkjTE3ZWXMHA02Dn/8rneLzHyWxNnrkZh6ZA/Dx9GWsxy2keZo0KwBJ320s By7prnQ9VMmn67k9PekWXQuDoZ/dsKracxjGAErIHf6jN5Vv+9hwt93BwWW8Dw+WEIfIb/Uaq DRFTr6/XM4TTffFDxicpoZRhjuu+lY1PFbpIeh+f+pBeQkRwM89r4INB6Wj7txqjnQpf5q3Zz 93ePPCA== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Wed, Mar 26, 2025 at 04:36:55PM -0400 schrieb Tom Lane: > It is intentional that this happens even if the reference to > private_col is subsequently optimized away. To do otherwise > would make implementation artifacts in the optimizer far too > visible, and there's also a very strong case that it would > violate the SQL standard. That's what I wanted to know. Thanks, Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B