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 1rOjBe-006cFj-6s for pgsql-committers@arkaria.postgresql.org; Sat, 13 Jan 2024 18:56:54 +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 1rOjBd-0097t8-59 for pgsql-committers@arkaria.postgresql.org; Sat, 13 Jan 2024 18:56:53 +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 1rOj9Q-0093J8-9F for pgsql-committers@lists.postgresql.org; Sat, 13 Jan 2024 18:54:36 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOj9L-001bF1-7v for pgsql-committers@lists.postgresql.org; Sat, 13 Jan 2024 18:54:35 +0000 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.94.2) (envelope-from ) id 1rOj9I-0048zu-5d for pgsql-committers@lists.postgresql.org; Sat, 13 Jan 2024 18:54:29 +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 1rOj9H-001HHb-HV for pgsql-committers@lists.postgresql.org; Sat, 13 Jan 2024 18:54:27 +0000 Content-Type: multipart/mixed; boundary="===============7093137617160244311==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Cope with catcache entries becoming stale during detoasting. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 13 Jan 2024 18:54:27 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7093137617160244311== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q29wZSB3aXRoIGNhdGNhY2hlIGVudHJpZXMgYmVjb21pbmcgc3RhbGUgZHVyaW5nIGRldG9hc3Rp bmcuCgpXZSd2ZSBsb25nIGhhZCBhIHBvbGljeSB0aGF0IGFueSB0b2FzdGVkIGZpZWxkcyBpbiBh IGNhdGFsb2cgdHVwbGUKc2hvdWxkIGJlIHB1bGxlZCBpbi1saW5lIGJlZm9yZSBlbnRlcmluZyB0 aGUgdHVwbGUgaW4gYSBjYXRhbG9nIGNhY2hlLgpIb3dldmVyLCB0aGF0IHJlcXVpcmVzIGFjY2Vz cyB0byB0aGUgY2F0YWxvZydzIHRvYXN0IHRhYmxlLCBhbmQgd2UnbGwKdHlwaWNhbGx5IGRvIEFj Y2VwdEludmFsaWRhdGlvbk1lc3NhZ2VzIHdoaWxlIG9wZW5pbmcgdGhlIHRvYXN0IHRhYmxlLgpT byBpdCdzIHBvc3NpYmxlIHRoYXQgdGhlIGNhdGFsb2cgdHVwbGUgaXMgb3V0ZGF0ZWQgYnkgdGhl IHRpbWUgd2UKZmluaXNoIGRldG9hc3RpbmcgaXQuICBTaW5jZSBubyBjYWNoZSBlbnRyeSBleGlz dHMgeWV0LCB3ZSBjYW4ndAptYXJrIHRoZSBlbnRyeSBzdGFsZSBkdXJpbmcgQWNjZXB0SW52YWxp ZGF0aW9uTWVzc2FnZXMsIGFuZCBpbnN0ZWFkCndlJ2xsIHByZXNzIGZvcndhcmQgYW5kIGJ1aWxk IGFuIGFwcGFyZW50bHktdmFsaWQgY2FjaGUgZW50cnkuICBUaGUKdXBzaG90IGlzIHRoYXQgd2Ug aGF2ZSBhIHJhY2UgY29uZGl0aW9uIHdoZXJlYnkgYW4gb3V0LW9mLWRhdGUgZW50cnkKY291bGQg YmUgbWFkZSBpbiBhIGJhY2tlbmQncyBjYXRhbG9nIGNhY2hlLCBhbmQgcGVyc2lzdCB0aGVyZQpp bmRlZmluaXRlbHkgY2F1c2luZyBpbmRldGVybWluYXRlIG1pc2JlaGF2aW9yLgoKVG8gZml4LCB1 c2UgdGhlIGV4aXN0aW5nIHN5c3RhYmxlX3JlY2hlY2tfdHVwbGUgY29kZSB0byByZWNoZWNrCndo ZXRoZXIgdGhlIGNhdGFsb2cgdHVwbGUgaXMgc3RpbGwgdXAtdG8tZGF0ZSBhZnRlciB3ZSBmaW5p c2gKZGV0b2FzdGluZyBpdC4gIElmIG5vdCwgbG9vcCBhcm91bmQgYW5kIHJlc3RhcnQgdGhlIHBy b2Nlc3Mgb2YKc2VhcmNoaW5nIHRoZSBjYXRhbG9nIGFuZCBjb25zdHJ1Y3RpbmcgY2FjaGUgZW50 cmllcyBmcm9tIHRoZSB0b3AuClRoZSBjYXNlIGlzIHJhcmUgZW5vdWdoIHRoYXQgdGhpcyBzaG91 bGRuJ3QgY3JlYXRlIGFueSBtZWFuaW5nZnVsCnBlcmZvcm1hbmNlIHBlbmFsdHksIGV2ZW4gaW4g dGhlIFNlYXJjaENhdENhY2hlTGlzdCBjYXNlIHdoZXJlCndlIG5lZWQgdG8gdGVhciBkb3duIGFu ZCByZWNvbnN0cnVjdCB0aGUgd2hvbGUgbGlzdC4KCkluZGVlZCwgdGhlIGNhc2UgaXMgc28gcmFy ZSB0aGF0IEFGQUlDVCBpdCBkb2Vzbid0IG9jY3VyIGR1cmluZwpvdXIgcmVncmVzc2lvbiB0ZXN0 cywgYW5kIHRoZXJlIGRvZXNuJ3Qgc2VlbSB0byBiZSBhbnkgZWFzeSB3YXkKdG8gYnVpbGQgYSB0 ZXN0IHRoYXQgd291bGQgZXhlcmNpc2UgaXQgcmVsaWFibHkuICBUbyBhbGxvdwp0ZXN0aW5nIG9m IHRoZSByZXRyeSBjb2RlIHBhdGhzLCBhZGQgbG9naWMgKGluIFVTRV9BU1NFUlRfQ0hFQ0tJTkcK YnVpbGRzIG9ubHkpIHRoYXQgcmFuZG9tbHkgcHJldGVuZHMgdGhhdCB0aGUgcmVjaGVjayBmYWls ZWQgYWJvdXQKb25lIHRpbWUgb3V0IG9mIGEgdGhvdXNhbmQuICBUaGlzIGlzIGVub3VnaCB0byBl bnN1cmUgdGhhdCB3ZSdsbApwYXNzIHRocm91Z2ggdGhlIHJldHJ5IHBhdGhzIGR1cmluZyBtb3N0 IHJlZ3Jlc3Npb24gdGVzdCBydW5zLgoKQnkgYWRkaW5nIGFuIGV4dHJhIGxldmVsIG9mIGxvb3Bp bmcsIHRoaXMgY29tbWl0IGNyZWF0ZXMgYSBuZWVkCnRvIHJlaW5kZW50IG1vc3Qgb2YgU2VhcmNo Q2F0Q2FjaGVNaXNzIGFuZCBTZWFyY2hDYXRDYWNoZUxpc3QuCkknbGwgZG8gdGhhdCBzZXBhcmF0 ZWx5LCB0byBhbGxvdyBwdXR0aW5nIHRob3NlIGNoYW5nZXMgaW4KLmdpdC1ibGFtZS1pZ25vcmUt cmV2cy4KClBhdGNoIGJ5IG1lOyB0aGFua3MgdG8gQWxleGFuZGVyIExha2hpbiBmb3IgaGF2aW5n IGJ1aWx0IGEgdGVzdApjYXNlIHRvIHByb3ZlIHRoZSBidWcgaXMgcmVhbCwgYW5kIHRvIFhpYW9y YW4gV2FuZyBmb3IgcmV2aWV3LgpCYWNrLXBhdGNoIHRvIGFsbCBzdXBwb3J0ZWQgYnJhbmNoZXMu CgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzEzOTM5NTMuMTY5ODM1MzAxM0Bzc3Mu cGdoLnBhLnVzCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FHamhMa09vQkVDOW1M c25CNDJkM0NPMXZjTXg3MU1MU0V1aWdlQUJiUThvUmRBNmd3QG1haWwuZ21haWwuY29tCgpCcmFu Y2gKLS0tLS0tClJFTF8xNl9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0 Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzdlMjU2MWUxYTI1OGNlZDQyNTBjNWQ1ZDFiM2IwMjIx OTMwZGJmN2UKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxz L2NhY2hlL2NhdGNhY2hlLmMgfCAxNjQgKysrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0t LS0tLQoxIGZpbGUgY2hhbmdlZCwgMTI0IGluc2VydGlvbnMoKyksIDQwIGRlbGV0aW9ucygtKQoK --===============7093137617160244311==--