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-47 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-00AdHT-1Z 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 1qZCns-00Aal2-3S for pgsql-committers@lists.postgresql.org; Thu, 24 Aug 2023 16:03:23 +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-000jcm-Lp for pgsql-committers@lists.postgresql.org; Thu, 24 Aug 2023 16:03:22 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qZCnk-0002RV-R5 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-000gGd-Nj for pgsql-committers@lists.postgresql.org; Thu, 24 Aug 2023 16:03:16 +0000 Content-Type: multipart/mixed; boundary="===============7348691660619067828==" 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 --===============7348691660619067828== 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 c3FsLm9yZwoKQnJhbmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi84NzAwODUxMzUyYTg5ZTllNzhk YTlkZjMxZmQ2ZDNhNzVkZjk4NDcwCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMv YmFja2VuZC9wYXJzZXIvYW5hbHl6ZS5jICAgICAgICAgICAgICAgICB8IDUyICsrKysrKysrKysr KysrKysrKy0tLQpzcmMvYmFja2VuZC91dGlscy9jYWNoZS9wbGFuY2FjaGUuYyAgICAgICAgICB8 IDY5ICsrKysrKysrKysrLS0tLS0tLS0tLS0tLS0tLS0Kc3JjL2luY2x1ZGUvcGFyc2VyL2FuYWx5 emUuaCAgICAgICAgICAgICAgICAgfCAgMSArCnNyYy9wbC9wbHBnc3FsL3NyYy9leHBlY3RlZC9w bHBnc3FsX2NhbGwub3V0IHwgMTcgKysrKysrKwpzcmMvcGwvcGxwZ3NxbC9zcmMvc3FsL3BscGdz cWxfY2FsbC5zcWwgICAgICB8IDE4ICsrKysrKysrCjUgZmlsZXMgY2hhbmdlZCwgMTA4IGluc2Vy dGlvbnMoKyksIDQ5IGRlbGV0aW9ucygtKQoK --===============7348691660619067828==--