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.96) (envelope-from ) id 1w5sAN-003iH9-0Y for pgsql-committers@arkaria.postgresql.org; Thu, 26 Mar 2026 21:22:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5sAL-005Pln-0d for pgsql-committers@arkaria.postgresql.org; Thu, 26 Mar 2026 21:22:57 +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.96) (envelope-from ) id 1w5sAK-005PlU-38 for pgsql-committers@lists.postgresql.org; Thu, 26 Mar 2026 21:22:57 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w5sAH-00000001CnU-1Oz0 for pgsql-committers@lists.postgresql.org; Thu, 26 Mar 2026 21:22:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Fndwbh3kL/Ua29Dr/VyMxJcTTCmRICk8KSeh+VN1R7I=; b=JkWheoKdOwPgRjWVuBw972Cwd0 wO+yBbMoFEH/hUTBcVt1VqXMMzhU1SG4DBKTOLnvi+4sAN+QNs/Rajf7U7COCVywQeHe+LlvKYlCy jVbb3cTQPdy5/HSlM7HBw0xLjtqe8S+Gg6qAp0hRhiwciMpq1i70Ct/hLmCIl/J0+X6DMIq05q/8E h81s88F3ATev7WcTP2uZMt5SKDkZZO6hgPBVhbr9zZIAl0/mlGoGaLXdf8OYrgnh5OZdpwC3ZIiXW 7B/fpvdNwXX/e9ABv8yyHPiDrD/UW/9xNIJ3svs2zs8rXHQnikNnoIv7gs3XPJ9VYsjO03TyOoHNM U5lPWVSg==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w5sAG-0050Ks-2z for pgsql-committers@lists.postgresql.org; Thu, 26 Mar 2026 21:22:53 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5sAF-001ayj-2i for pgsql-committers@lists.postgresql.org; Thu, 26 Mar 2026 21:22:52 +0000 Content-Type: multipart/mixed; boundary="===============2525003561128100265==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: pg_plan_advice: Invent DO_NOT_SCAN(relation_identifier). X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 26 Mar 2026 21:22:52 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2525003561128100265== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 cGdfcGxhbl9hZHZpY2U6IEludmVudCBET19OT1RfU0NBTihyZWxhdGlvbl9pZGVudGlmaWVyKS4K ClRoZSBwcmVtaXNlIG9mIHNyYy90ZXN0L21vZHVsZXMvdGVzdF9wbGFuX2FkdmljZSBpcyB0aGF0 IGlmIHdlIHBsYW4KYSBxdWVyeSBvbmNlLCBnZW5lcmF0ZSBwbGFuIGFkdmljZSwgYW5kIHRoZW4g cmVwbGFuIGl0IHVzaW5nIHRoYXQKc2FtZSBhZHZpY2UsIGFsbCBvZiB0aGF0IGFkdmljZSBzaG91 bGQgYXBwbHkgY2xlYW5seSwgc2luY2UgdGhlCnNldHRpbmdzIGFuZCBldmVyeXRoaW5nIGVsc2Ug YXJlIHRoZSBzYW1lLiBVbmZvcnR1bmF0ZWx5LCB0aGF0J3MKbm90IHRoZSBjYXNlOiB0aGUgdGVz dCBzdWl0ZSBpcyB0aGUgbWFpbiByZWdyZXNzaW9uIHRlc3RzLCBhbmQKY29uY3VycmVudCBhY3Rp dml0eSBjYW4gY2hhbmdlIHRoZSBzdGF0aXN0aWNzIG9uIHRhYmxlcyBpbnZvbHZlZAppbiB0aGUg cXVlcnksIGVzcGVjaWFsbHkgc3lzdGVtIGNhdGFsb2dzLiBUaGF0J3MgT0sgYXMgbG9uZyBhcyBp dApvbmx5IGFmZmVjdHMgY29zdGluZywgYnV0IGluIGEgZmV3IGNhc2VzLCBpdCBhZmZlY3RzIHdo aWNoIHJlbGF0aW9ucwphcHBlYXIgaW4gdGhlIGZpbmFsIHBsYW4gYXQgYWxsLgoKSW4gdGhlIGJ1 aWxkZmFybSBmYWlsdXJlcyBvYnNlcnZlZCB0byBkYXRlLCB0aGlzIGhhcHBlbnMgYmVjYXVzZQp3 ZSBjb25zaWRlciBhbHRlcm5hdGl2ZSBzdWJwbGFucyBmb3IgdGhlIHNhbWUgcG9ydGlvbiBvZiB0 aGUgcXVlcnk7CmluIHRoZW9yeSwgTWluTWF4QWdnUGF0aCBpcyB2dWxuZXJhYmxlIHRvIGEgc2lt aWxhciBoYXphcmQuIEluIGJvdGgKY2FzZXMsIHRoZSBwbGFubmVyIGNsb25lcyBhbiBlbnRpcmUg c3VicXVlcnksIGFuZCB0aGUgY2xvbmUgaGFzIGEKZGlmZmVyZW50IHBsYW4gbmFtZSwgYW5kIHRo ZXJlZm9yZSBkaWZmZXJlbnQgcmFuZ2UgdGFibGUgaWRlbnRpZmllcnMsCnRoYW4gdGhlIG9yaWdp bmFsLiBJZiBhIGNvc3QgY2hhbmdlIHJlc3VsdHMgaW4gZmxpcHBpbmcgYmV0d2VlbiBvbmUKb2Yg dGhlc2UgcGxhbnMgYW5kIHRoZSBvdGhlciwgdGhlIHRlc3RfcGxhbl9hZHZpY2UgdGVzdHMgd2ls bCBmYWlsLApiZWNhdXNlIHRoZSByYW5nZSB0YWJsZSBpZGVudGlmaWVycyB0byB3aGljaCBhZHZp Y2Ugd2FzIGFwcGxpZWQgd29uJ3QKZXZlbiBiZSBwcmVzZW50IGluIHRoZSBvdXRwdXQgb2YgdGhl IHNlY29uZCBwbGFubmluZyBjeWNsZS4KClRvIGZpeCwgaW52ZW50IGEgbmV3IERPX05PVF9TQ0FO IGFkdmljZSB0YWcuIFdoZW4gZ2VuZXJhdGluZyBhZHZpY2UsCmVtaXQgaXQgZm9yIHJlbGF0aW9u cyB0aGF0IHNob3VsZCBub3QgYXBwZWFyIGluIHRoZSBmaW5hbCBwbGFuIGF0CmFsbCwgYmVjYXVz ZSBzb21lIGFsdGVybmF0aXZlIHZlcnNpb24gb2YgdGhhdCByZWxhdGlvbiB3YXMgdXNlZAppbnN0 ZWFkLiBXaGVuIERPX05PVF9TQ0FOIGlzIHN1cHBsaWVkLCBkaXNhYmxlIGFsbCBzY2FuIG1ldGhv ZHMgZm9yCnRoYXQgcmVsYXRpb24uCgpUbyBtYWtlIHRoaXMgd29yaywgd2UgcmV1c2UgYSBidW5j aCBvZiB0aGUgbWFjaGluZXJ5IHRoYXQgcHJldmlvdXNseQpleGlzdGVkIGZvciB0aGUgcHVycG9z ZSBvZiBlbnN1cmluZyB0aGF0IHdlIGJ1aWxkIHRoZSBzYW1lIHNldCBvZgpyZWxhdGlvbiBpZGVu dGlmaWVycyBkdXJpbmcgcGxhbm5pbmcgYXMgd2UgZG8gZnJvbSB0aGUgZmluYWwKUGxhbm5lZFN0 bXQuIEluIHRoZSBwcm9jZXNzLCB0aGlzIGNvbW1pdCBzbGlnaHRseSB3ZWFrZW5zIHRoZQpjcm9z cy1jaGVjayBtZWNoYW5pc206IGJlZm9yZSB0aGlzIGNvbW1pdCwgaXQgd291bGQgZmlyZSB3aGVu ZXZlcgp0aGUgcGdfcGxhbl9hZHZpY2UgbW9kdWxlIHdhcyBsb2FkZWQsIGV2ZW4gaWYgcGdfcGxh bl9hZHZpY2Ugd2Fzbid0CmFjdHVhbGx5IGRvaW5nIGFueXRoaW5nOyBub3csIGl0IHdpbGwgb25s eSBlbmdhZ2Ugd2hlbiB3ZSBoYXZlIHNvbWUKb3RoZXIgcmVhc29uIHRvIGNyZWF0ZSBhIHBncGFf cGxhbm5lcl9zdGF0ZS4gVGhlIG9sZCB3YXkgd2FzIGNvbXBsZXgKYW5kIGRpZG4ndCBhZGQgbXVj aCB1c2VmdWwgdGVzdCBjb3ZlcmFnZSwgc28gdGhpcyBzZWVtcyBsaWtlIGFuCmFjY2VwdGFibGUg c2FjcmlmaWNlLgoKRGlzY3Vzc2lvbjogaHR0cDovL3Bvc3Rnci5lcy9tL0NBK1RnbW9ZdVdtTi0w MEVjNXBZN3pBY3BTRlFVUUxiZ0FkVldHUjlrT1ItSE0tZkhyQUBtYWlsLmdtYWlsLmNvbQpSZXZp ZXdlZC1ieTogTHVrYXMgRml0dGwgPGx1a2FzQGZpdHRsLmNvbT4KCkJyYW5jaAotLS0tLS0KbWFz dGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0 ZGlmZi82NDU1ZTU1YjBkYTQ3MjU1ZjMzMmE5NmYwMDViYTBkZDFjNzE3NmMyCgpNb2RpZmllZCBG aWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmliL3BnX3BsYW5fYWR2aWNlL1JFQURNRSAgICAgICAg ICAgICAgICAgICAgfCAgIDcgKwpjb250cmliL3BnX3BsYW5fYWR2aWNlL2V4cGVjdGVkL2FsdGVy bmF0aXZlcy5vdXQgfCAxNTggKysrKysrKysrKysrKysrKysKY29udHJpYi9wZ19wbGFuX2Fkdmlj ZS9leHBlY3RlZC9zY2FuLm91dCAgICAgICAgIHwgIDE3ICstCmNvbnRyaWIvcGdfcGxhbl9hZHZp Y2UvbWVzb24uYnVpbGQgICAgICAgICAgICAgICB8ICAgMSArCmNvbnRyaWIvcGdfcGxhbl9hZHZp Y2UvcGdwYV9hc3QuYyAgICAgICAgICAgICAgICB8ICAgNiArCmNvbnRyaWIvcGdfcGxhbl9hZHZp Y2UvcGdwYV9hc3QuaCAgICAgICAgICAgICAgICB8ICAgMSArCmNvbnRyaWIvcGdfcGxhbl9hZHZp Y2UvcGdwYV9vdXRwdXQuYyAgICAgICAgICAgICB8ICAzNSArKysrCmNvbnRyaWIvcGdfcGxhbl9h ZHZpY2UvcGdwYV9wbGFubmVyLmMgICAgICAgICAgICB8IDIxMyArKysrKysrKysrKysrLS0tLS0t LS0tLQpjb250cmliL3BnX3BsYW5fYWR2aWNlL3BncGFfcGxhbm5lci5oICAgICAgICAgICAgfCAg MjYgKystCmNvbnRyaWIvcGdfcGxhbl9hZHZpY2UvcGdwYV90cm92ZS5jICAgICAgICAgICAgICB8 ICAgMSArCmNvbnRyaWIvcGdfcGxhbl9hZHZpY2UvcGdwYV93YWxrZXIuYyAgICAgICAgICAgICB8 IDE1NiArKysrKysrKysrKysrKy0tLQpjb250cmliL3BnX3BsYW5fYWR2aWNlL3BncGFfd2Fsa2Vy LmggICAgICAgICAgICAgfCAgIDEgKwpjb250cmliL3BnX3BsYW5fYWR2aWNlL3NxbC9hbHRlcm5h dGl2ZXMuc3FsICAgICAgfCAgNTggKysrKysrCmNvbnRyaWIvcGdfcGxhbl9hZHZpY2Uvc3FsL3Nj YW4uc3FsICAgICAgICAgICAgICB8ICAgNSArLQpkb2Mvc3JjL3NnbWwvcGdwbGFuYWR2aWNlLnNn bWwgICAgICAgICAgICAgICAgICAgfCAgMTQgKy0KMTUgZmlsZXMgY2hhbmdlZCwgNTgxIGluc2Vy dGlvbnMoKyksIDExOCBkZWxldGlvbnMoLSkKCg== --===============2525003561128100265==--