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 1qZCot-004bDN-B1 for pgsql-committers@arkaria.postgresql.org; Thu, 24 Aug 2023 16:04:27 +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 1qZCos-00AdHX-1j for pgsql-committers@arkaria.postgresql.org; Thu, 24 Aug 2023 16:04:25 +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 1qZCnt-00Ab3O-EM for pgsql-committers@lists.postgresql.org; Thu, 24 Aug 2023 16:03:25 +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.94.2) (envelope-from ) id 1qZCnl-000jco-LE for pgsql-committers@lists.postgresql.org; Thu, 24 Aug 2023 16:03:23 +0000 Received: from gemulon.postgresql.org ([72.32.157.198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qZCnk-0002RZ-VK for pgsql-committers@lists.postgresql.org; Thu, 24 Aug 2023 16:03:16 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qZCnj-000gGp-Pp for pgsql-committers@lists.postgresql.org; Thu, 24 Aug 2023 16:03:16 +0000 Content-Type: multipart/mixed; boundary="===============1942471157728254195==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid unnecessary plancache revalidation of utility statements. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 24 Aug 2023 16:03:16 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1942471157728254195== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgdW5uZWNlc3NhcnkgcGxhbmNhY2hlIHJldmFsaWRhdGlvbiBvZiB1dGlsaXR5IHN0YXRl bWVudHMuCgpSZXZhbGlkYXRpb24gb2YgYSBwbGFuY2FjaGUgZW50cnkgKGFmdGVyIGEgY2FjaGUg aW52YWxpZGF0aW9uIGV2ZW50KQpyZXF1aXJlcyBhY3F1aXJpbmcgYSBzbmFwc2hvdC4gIE5vcm1h bGx5IHRoYXQgaXMgaGFybWxlc3MsIGJ1dCBub3QKaWYgdGhlIGNhY2hlZCBzdGF0ZW1lbnQgaXMg b25lIHRoYXQgbmVlZHMgdG8gcnVuIHdpdGhvdXQgYWNxdWlyaW5nIGEKc25hcHNob3QuICBXZSB3 ZXJlIGFscmVhZHkgYXdhcmUgb2YgdGhhdCBmb3IgVHJhbnNhY3Rpb25TdG10cywKYnV0IGZvciBz b21lIHJlYXNvbiBoYWRuJ3QgZXh0cmFwb2xhdGVkIHRvIHRoZSBvdGhlciBzdGF0ZW1lbnRzIHRo YXQKUGxhbm5lZFN0bXRSZXF1aXJlc1NuYXBzaG90KCkga25vd3MgbXVzdG4ndCBzZXQgYSBzbmFw c2hvdC4gIFRoaXMgY2FuCmxlYWQgdG8gdW5leHBlY3RlZCBmYWlsdXJlcyBvZiBjb21tYW5kcyBz dWNoIGFzIFNFVCBUUkFOU0FDVElPTgpJU09MQVRJT04gTEVWRUwuICBXZSBjYW4gZml4IGl0IGlu IHRoZSBzYW1lIHdheSwgYnkgZXhjbHVkaW5nIHRob3NlCmNvbW1hbmQgdHlwZXMgZnJvbSByZXZh bGlkYXRpb24uCgpIb3dldmVyLCB3ZSBjYW4gZG8gZXZlbiBiZXR0ZXIgdGhhbiB0aGF0OiB0aGVy ZSBpcyBubyBuZWVkIHRvCnJldmFsaWRhdGUgZm9yIGFueSBzdGF0ZW1lbnQgdHlwZSBmb3Igd2hp Y2ggcGFyc2UgYW5hbHlzaXMsIHJld3JpdGUsCmFuZCBwbGFuIHN0ZXBzIGRvIG5vdGhpbmcgaW50 ZXJlc3RpbmcsIHdoaWNoIGlzIG5lYXJseSBhbGwgdXRpbGl0eQpjb21tYW5kcy4gIFRvIG1lY2hh bml6ZSB0aGlzLCBpbnZlbnQgYSBwYXJzZXIgZnVuY3Rpb24Kc3RtdF9yZXF1aXJlc19wYXJzZV9h bmFseXNpcygpIHRoYXQgdGVsbHMgd2hldGhlciBwYXJzZSBhbmFseXNpcyBkb2VzCmFueXRoaW5n IGJleW9uZCB3cmFwcGluZyBhIENNRF9VVElMSVRZIFF1ZXJ5IGFyb3VuZCB0aGUgcmF3IHBhcnNl CnRyZWUuICBJZiB0aGF0J3Mgd2hhdCBpdCBkb2VzLCB0aGVuIHJld3JpdGUgYW5kIHBsYW4gd2ls bCBqdXN0CnNraXAgdGhlIFF1ZXJ5LCBzbyB0aGF0IGl0IGlzIG5vdCBwb3NzaWJsZSBmb3IgdGhl IHNhbWUgcmF3IHBhcnNlCnRyZWUgdG8gcHJvZHVjZSBhIGRpZmZlcmVudCBwbGFuIHRyZWUgYWZ0 ZXIgY2FjaGUgaW52YWxpZGF0aW9uLgoKc3RtdF9yZXF1aXJlc19wYXJzZV9hbmFseXNpcygpIGlz IGJhc2ljYWxseSBlcXVpdmFsZW50IHRvIHRoZQpleGlzdGluZyBmdW5jdGlvbiBhbmFseXplX3Jl cXVpcmVzX3NuYXBzaG90KCksIGV4Y2VwdCB0aGF0IGZvcgpvYnNjdXJlIHJlYXNvbnMgdGhhdCBm dW5jdGlvbiBvbWl0cyBSZXR1cm5TdG10IGFuZCBDYWxsU3RtdC4KSXQgaXMgdW5jbGVhciB3aGV0 aGVyIHRob3NlIHdlcmUgb3ZlcnNpZ2h0cyBvciBpbnRlbnRpb25hbC4KSSBoYXZlIG5vdCBiZWVu IGFibGUgdG8gZGVtb25zdHJhdGUgYSBidWcgZnJvbSBub3QgYWNxdWlyaW5nIGEKc25hcHNob3Qg d2hpbGUgYW5hbHl6aW5nIHRoZXNlIGNvbW1hbmRzLCBidXQgYXQgYmVzdCBpdCBzZWVtcyBtaWdo dHkKZnJhZ2lsZS4gIEl0IHNlZW1zIHNhZmVyIHRvIGFjcXVpcmUgYSBzbmFwc2hvdCBmb3IgcGFy c2UgYW5hbHlzaXMgb2YKdGhlc2UgY29tbWFuZHMgdG9vLCB3aGljaCBhbGxvd3MgbWFraW5nIHN0 bXRfcmVxdWlyZXNfcGFyc2VfYW5hbHlzaXMKYW5kIGFuYWx5emVfcmVxdWlyZXNfc25hcHNob3Qg ZXF1aXZhbGVudC4KCkluIHBhc3NpbmcgdGhpcyBmaXhlcyBhIHNlY29uZCBidWcsIHdoaWNoIGlz IHRoYXQgUmVzZXRQbGFuQ2FjaGUKd291bGQgZXhjbHVkZSBSZXR1cm5TdG10cyBhbmQgQ2FsbFN0 bXRzIGZyb20gcmV2YWxpZGF0aW9uLgpUaGF0J3Mgc3VyZWx5ICpub3QqIHNhZmUsIHNpbmNlIHRo ZXkgY29udGFpbiBwYXJzYWJsZSBleHByZXNzaW9ucy4KClBlciBidWcgIzE4MDU5IGZyb20gUGF2 ZWwgS3VsYWtvdi4gIEJhY2stcGF0Y2ggdG8gYWxsIHN1cHBvcnRlZApicmFuY2hlcy4KCkRpc2N1 c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTgwNTktNzljNjkyZjAzNmIyNTM0NkBwb3N0Z3Jl c3FsLm9yZwoKQnJhbmNoCi0tLS0tLQpSRUxfMTFfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85YzU5ZjM4NjJiMTgyZGZmYTg1 ZTdkMWVhOTI0MTg3YzIyYWNlMDg2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMv YmFja2VuZC9wYXJzZXIvYW5hbHl6ZS5jICAgICAgICAgICAgICAgICB8IDUxICsrKysrKysrKysr KysrKysrLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL3BsYW5jYWNoZS5jICAgICAgICAgIHwg NzAgKysrKysrKysrKystLS0tLS0tLS0tLS0tLS0tLQpzcmMvaW5jbHVkZS9wYXJzZXIvYW5hbHl6 ZS5oICAgICAgICAgICAgICAgICB8ICAxICsKc3JjL3BsL3BscGdzcWwvc3JjL2V4cGVjdGVkL3Bs cGdzcWxfY2FsbC5vdXQgfCAxNyArKysrKysrCnNyYy9wbC9wbHBnc3FsL3NyYy9zcWwvcGxwZ3Nx bF9jYWxsLnNxbCAgICAgIHwgMTggKysrKysrKwo1IGZpbGVzIGNoYW5nZWQsIDEwNyBpbnNlcnRp b25zKCspLCA1MCBkZWxldGlvbnMoLSkKCg== --===============1942471157728254195==--