Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8Ro9-00083R-AB for pgsql-committers@arkaria.postgresql.org; Fri, 14 Jan 2022 19:00:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8Ro7-0005xZ-K1 for pgsql-committers@arkaria.postgresql.org; Fri, 14 Jan 2022 19:00:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8Ro7-0005xQ-CH for pgsql-committers@lists.postgresql.org; Fri, 14 Jan 2022 19:00:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n8Ro0-00021Q-7X for pgsql-committers@lists.postgresql.org; Fri, 14 Jan 2022 19:00:15 +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 1n8Rnx-0004yn-Vk for pgsql-committers@lists.postgresql.org; Fri, 14 Jan 2022 19:00:05 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8Rnx-0003Ww-8e for pgsql-committers@lists.postgresql.org; Fri, 14 Jan 2022 19:00:05 +0000 Content-Type: multipart/mixed; boundary="===============7371599429771344465==" MIME-Version: 1.0 From: Andres Freund To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix possible HOT corruption when RECENTLY_DEAD changes to DEAD w X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 14 Jan 2022 19:00:05 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7371599429771344465== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBvc3NpYmxlIEhPVCBjb3JydXB0aW9uIHdoZW4gUkVDRU5UTFlfREVBRCBjaGFuZ2VzIHRv IERFQUQgd2hpbGUgcHJ1bmluZy4KClNpbmNlIGRjNzQyMGMyYzkyIHRoZSBob3Jpem9uIHVzZWQg Zm9yIHBydW5pbmcgaXMgZGV0ZXJtaW5lZCAibGF6aWx5Ii4gQSBtb3JlCmFjY3VyYXRlIGhvcml6 b24gaXMgYnVpbHQgb24tZGVtYW5kLCByYXRoZXIgdGhhbiBpbiBHZXRTbmFwc2hvdERhdGEoKS4g SWYgYQpob3Jpem9uIGNvbXB1dGF0aW9uIGlzIHRyaWdnZXJlZCBiZXR3ZWVuIHR3byBIZWFwVHVw bGVTYXRpc2ZpZXNWYWN1dW0oKSBjYWxscwpmb3IgdGhlIHNhbWUgdHVwbGUsIHRoZSByZXN1bHQg Y2FuIGNoYW5nZSBmcm9tIFJFQ0VOVExZX0RFQUQgdG8gREVBRC4KCmhlYXBfcGFnZV9wcnVuZSgp IGNhbiBwcm9jZXNzIHRoZSBzYW1lIHRpZCBtdWx0aXBsZSB0aW1lcyAob25jZSBmb2xsb3dpbmcg YW4KdXBkYXRlIGNoYWluLCBvbmNlICJkaXJlY3RseSIpLiBXaGVuIHRoZSByZXN1bHQgb2YgSGVh cFR1cGxlU2F0aXNmaWVzVmFjdXVtKCkKb2YgYSB0dXBsZSBjaGFuZ2VzIGZyb20gUkVDRU5UTFlf REVBRCBkdXJpbmcgdGhlIGZpcnN0IGFjY2VzcywgdG8gREVBRCBpbiB0aGUKc2Vjb25kLCB0aGUg InR1cGxlIGlzIERFQUQgYW5kIGRvZXNuJ3QgY2hhaW4gdG8gYW55dGhpbmcgZWxzZSIgcGF0aCBp bgpoZWFwX3BydW5lX2NoYWluKCkgY2FuIGVuZCB1cCBtYXJraW5nIHRoZSB0YXJnZXQgb2YgYSBM UF9SRURJUkVDVCBJdGVtSWQKdW51c2VkLgoKSW5pdGlhbGx5IG5vdCBlYXNpbHkgdmlzaWJsZSwK T25jZSB0aGUgdGFyZ2V0IG9mIGEgTFBfUkVESVJFQ1QgSXRlbUlkIGlzIG1hcmtlZCB1bnVzZWQs IGEgbmV3IHR1cGxlIHZlcnNpb24KY2FuIHJldXNlIGl0LiBBdCB0aGF0IHBvaW50IHRoZSBjb3Jy dXB0aW9uIG1heSBiZWNvbWUgdmlzaWJsZSwgYXMgaW5kZXgKZW50cmllcyBwb2ludGluZyB0byB0 aGUgIm9yaWdpbmFsIiByZWRpcmVjdCBpdGVtLCBub3cgcG9pbnQgdG8gYSB1bnJlbGF0ZWQKdHVw bGUuCgpUbyBmaXgsIGNvbXB1dGUgSFRTViBmb3IgYWxsIHR1cGxlcyBvbiBhIHBhZ2Ugb25seSBv bmNlLiBUaGlzIGZpeGVzIHRoZSBlbnRpcmUKY2xhc3Mgb2YgcHJvYmxlbXMgb2YgSFRTViBjaGFu Z2luZyBpbnNpZGUgaGVhcF9wYWdlX3BydW5lKCkuIEhvd2V2ZXIsCnZpc2liaWxpdHkgY2hhbmdl cyBjYW4gb2J2aW91c2x5IHN0aWxsIG9jY3VyIGJldHdlZW4gSFRTViBjaGVja3MgaW5zaWRlCmhl YXBfcGFnZV9wcnVuZSgpIGFuZCBvdXRzaWRlIChlLmcuIGluIGxhenlfc2Nhbl9wcnVuZSgpKS4K ClRoZSBjb21wdXRhdGlvbiBvZiBIVFNWIGlzIG5vdyBkb25lIGluIGJ1bGssIGluIGhlYXBfcGFn ZV9wcnVuZSgpLCByYXRoZXIgdGhhbgpvbi1kZW1hbmQgaW4gaGVhcF9wcnVuZV9jaGFpbigpLiBC ZXNpZGVzIGJlaW5nIGEgYml0IHNpbXBsZXIsIGl0IGFsc28gaXMKZmFzdGVyOiBNZW1vcnkgYWNj ZXNzZXMgY2FuIGhhcHBlbiBzZXF1ZW50aWFsbHksIHJhdGhlciB0aGFuIGluIHRoZSBvcmRlciBv ZgpIT1QgY2hhaW5zLgoKVGhlcmUgYXJlIG90aGVyIGNhdXNlcyBvZiBIZWFwVHVwbGVTYXRpc2Zp ZXNWYWN1dW0oKSByZXN1bHRzIGNoYW5naW5nIGJldHdlZW4KdHdvIHZpc2liaWxpdHkgY2hlY2tz IGZvciB0aGUgc2FtZSB0dXBsZSwgZXZlbiBiZWZvcmUgZGM3NDIwYzJjOTIuIEUuZy4KSEVBUFRV UExFX0lOU0VSVF9JTl9QUk9HUkVTUyBjYW4gY2hhbmdlIHRvIEhFQVBUVVBMRV9ERUFEIHdoZW4g YSB0cmFuc2FjdGlvbgphYm9ydHMgYmV0d2VlbiB0aGUgdHdvIGNoZWNrcy4gTm9uZSBvZiB0aGUg dGhlc2Ugb3RoZXIgdmlzaWJpbGl0eSBzdGF0dXMKY2hhbmdlcyBhcmUga25vd24gdG8gY2F1c2Ug Y29ycnVwdGlvbiwgYnV0IGhlYXBfcGFnZV9wcnVuZSgpJ3MgYXBwcm9hY2ggbWFrZXMKaXQgaGFy ZCB0byBiZSBjb25maWRlbnQuCgpBIHBhdGNoIGltcGxlbWVudGluZyBhIG1vcmUgZnVuZGFtZW50 YWwgcmVkZXNpZ24gb2YgaGVhcF9wYWdlX3BydW5lKCksIHdoaWNoCmZpeGVzIHRoaXMgYnVnIGFu ZCBzaW1wbGlmaWVzIHBydW5pbmcgc3Vic3RhbnRpYWxseSwgaGFzIGJlZW4gcHJvcG9zZWQgYnkK UGV0ZXIgR2VvZ2hlZ2FuIGluCmh0dHBzOi8vcG9zdGdyLmVzL20vQ0FIMi1Xem1OazZWNnRxenV1 YWJ4b3hNOEhKUmFXVTZoMTJ0b2FTLWJxWWNMaWh0MTZBQG1haWwuZ21haWwuY29tCgpIb3dldmVy LCB0aGF0IHJlZGVzaWduIGlzIGxhcmdlciBjaGFuZ2UgdGhhbiBkZXNpcmFibGUgZm9yIGJhY2tw YXRjaGluZy4gQXMKdGhlIG5ldyBkZXNpZ24gc3RpbGwgYmVuZWZpdHMgZnJvbSB0aGUgYmF0Y2hl ZCB2aXNpYmlsaXR5IGRldGVybWluYXRpb24KaW50cm9kdWNlZCBpbiB0aGlzIGNvbW1pdCwgaXQg bWFrZXMgc2Vuc2UgdG8gY29tbWl0IHRoaXMgbmFycm93ZXIgZml4IHRvIDE0CmFuZCBtYXN0ZXIs IGFuZCB0aGVuIGNvbW1pdCBQZXRlcidzIGltcHJvdmVtZW50IGluIG1hc3Rlci4KClRoZSBwcmVj aXNlIHNlcXVlbmNlIHJlcXVpcmVkIHRvIHRyaWdnZXIgdGhlIGJ1ZyBpcyBjb21wbGljYXRlZCBh bmQgaGFyZCB0byBkbwpleGVyY2lzZSBpbiBhbiBpc29sYXRpb24gdGVzdCAodW50aWwgd2UgaGF2 ZSB3YWl0IHBvaW50cykuIER1ZSB0byB0aGF0IHRoZQppc29sYXRpb24gdGVzdCBpbml0aWFsbHkg cG9zdGVkIGF0Cmh0dHBzOi8vcG9zdGdyLmVzL20vMjAyMTExMTkwMDM2MjMuZDNqdXNpeXR6anF3 YjYycCU0MGFsYXAzLmFuYXJhemVsLmRlCmFuZCB1cGRhdGVkIGluCmh0dHBzOi8vcG9zdGdyLmVz L20vMjAyMTExMjIxNzU5MTQuYXlrNmdnNm52ZHd1aHJ6YiU0MGFsYXAzLmFuYXJhemVsLmRlCmlz bid0IGNvbW1pdHRhYmxlLgoKQSBmb2xsb3d1cCBjb21taXQgd2lsbCBpbnRyb2R1Y2UgYWRkaXRp b25hbCBhc3NlcnRpb25zLCB0byBkZXRlY3QgcHJvYmxlbXMKbGlrZSB0aGlzIG1vcmUgZWFzaWx5 LgoKQnVnOiAjMTcyNTUKUmVwb3J0ZWQtQnk6IEFsZXhhbmRlciBMYWtoaW4gPGV4Y2x1c2lvbkBn bWFpbC5jb20+CkRlYnVnZ2VkLUJ5OiBBbmRyZXMgRnJldW5kIDxhbmRyZXNAYW5hcmF6ZWwuZGU+ CkRlYnVnZ2VkLUJ5OiBQZXRlciBHZW9naGVnYW4gPHBnQGJvd3QuaWU+CkF1dGhvcjogQW5kcmVz IEZyZXVuZCA8YW5kcmVzQGFuZHJlc0BhbmFyYXplbC5kZT4KUmV2aWV3ZWQtQnk6IFBldGVyIEdl b2doZWdhbiA8cGdAYm93dC5pZT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMDIx MTEyMjE3NTkxNC5heWs2Z2c2bnZkd3VocnpiQGFsYXAzLmFuYXJhemVsLmRlCkJhY2twYXRjaDog MTQtLCB0aGUgb2xkZXN0IGJyYW5jaCBjb250YWluaW5nIGRjNzQyMGMyYzkyCgpCcmFuY2gKLS0t LS0tClJFTF8xNF9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3Fs Lm9yZy9wZy9jb21taXRkaWZmL2RhZDE1MzlhZWMyOGFlM2QwMjRiMDBhZTMyMmYwMmY3ZmUwYzQx ZWUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFw L3BydW5laGVhcC5jIHwgMTA3ICsrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLQox IGZpbGUgY2hhbmdlZCwgODIgaW5zZXJ0aW9ucygrKSwgMjUgZGVsZXRpb25zKC0pCgo= --===============7371599429771344465==--