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 1rPwv8-00FOIv-QX for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Jan 2024 03:48:55 +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 1rPwv7-00AJvX-Jc for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Jan 2024 03:48: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 1rPwv7-00AJvP-75 for pgsql-hackers@lists.postgresql.org; Wed, 17 Jan 2024 03:48:53 +0000 Received: from esa.hc2186-20.iphmx.com ([68.232.157.143]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPwv4-002E9j-0v for pgsql-hackers@postgresql.org; Wed, 17 Jan 2024 03:48:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=ebay.com; i=@ebay.com; q=dns/txt; s=ebaycorp; t=1705463331; x=1736999331; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=F1va+fbTR8vB869+RkrZkSw4PcjAUOPUyZYwu83OS+w=; b=G0xVMNJNDAVUD3NUMo7R45vZOJlivyz+YwjRR5BTbLM/w18zOgSgQM8x tCHJHqDKk84wpoJYrSbgFzEJYx1Zc+cTgEmShoEdBe0yUtyHphzNar/Tb sV1i6ajn0gBT1B1zbqJ/gKNAbzVT+55+JV+CE9a3B3dDXso7Fj2L1dWAy s=; X-IronPort-RemoteIP: 216.113.162.88 X-IronPort-MID: 246095684 X-IronPort-Reputation: 3.7 X-IronPort-Listener: OutboundMail X-IronPort-SenderGroup: Vontu_to_CES_Outbound X-IronPort-MailFlowPolicy: $Vontu_to_CES_Outbound X-EBay-Corp: Yes X-IronPort-AV: E=Sophos;i="6.05,200,1701158400"; d="scan'208";a="246095684" Received: from lvs-dlpoutbound.corp.ebay.com (HELO lvs-ipatom-001.corp.ebay.com) ([216.113.162.88]) by esa5.hc2186-20.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 16 Jan 2024 19:48:47 -0800 X-ATOM: Processed_By_ATOM X-IronPort-Trust: True Received: from mail-mw2nam12lp2041.outbound.protection.outlook.com (HELO NAM12-MW2-obe.outbound.protection.outlook.com) ([104.47.66.41]) by atom.corp.ebay.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 16 Jan 2024 19:48:46 -0800 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=JNhOCCMhyOTnKxUM2WaGBWD9E9TGXwrbAuLfwltAjdniNd6UmSpj3deQx0GDqp8DIyzAkNVQMhW3qI6t5lohBXnMMBbduFSoRzzIv+pou9OSuRQYsPnf4TA+jHJ8LlXFbdk8wncFiAIp7Bg/PLWVKWhR4FRSlqjUm4nbeksh/jZxE5ztS2fDsMeAmucFLFHl0MdfH1yjcw3roOtGLtsgsQEmB9Sg9E7dM77BhF1o7Ez6bRudBjsYYB23QIHSoLoav4qrmnusTcj1jiacbEjq0LIR7qOhhoEjYSURrRCMYCSK4Vv3OI++YrGKG7XO6teWizAXXuTcxPjH9q5LZvlDWQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=F1va+fbTR8vB869+RkrZkSw4PcjAUOPUyZYwu83OS+w=; b=WPTu3k0t0F1EaDMAgb4E0wokMOqkJPRHNVdixnMV1JeKjhJJS9yVd5FdYucwJNB8vRhjFUSlLeAM7zyHWWt7G42gYfxsQakuQ0wGNRCnFC+Dddnep2i8bppiJL/Hrd08rlaRn32ym38bDF6T34fWTFMD5TmRr21P2R8TZz2m64PoUkbmwZhOfWoyzzje7T4J/zwWK2lurF/POWJmjcJZ+Bom0vsOxsiSlfl6lGimSEfYKDyWqPCkE7+PgtDP/b0gl33te1uMxiydoJYBb36exM2ESLT4/0bYBEis5UjEL8eBBjyF8jDqBc/cmjCzbpEcr2YNM+A5RnM/IH0khVX6dA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ebay.com; dmarc=pass action=none header.from=ebay.com; dkim=pass header.d=ebay.com; arc=none Received: from IA1PR07MB9829.namprd07.prod.outlook.com (2603:10b6:208:457::10) by SA1PR07MB8426.namprd07.prod.outlook.com (2603:10b6:806:1ad::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7202.23; Wed, 17 Jan 2024 03:48:43 +0000 Received: from IA1PR07MB9829.namprd07.prod.outlook.com ([fe80::6f42:c972:40e7:972a]) by IA1PR07MB9829.namprd07.prod.outlook.com ([fe80::6f42:c972:40e7:972a%6]) with mapi id 15.20.7181.020; Wed, 17 Jan 2024 03:48:43 +0000 From: "Li, Yong" To: Nathan Bossart CC: Andres Freund , "pgsql-hackers@postgresql.org" Subject: Re: locked reads for atomics Thread-Topic: locked reads for atomics Thread-Index: AQHaSPQ68Z50//BsbUOp6jS/ZoLL8bDdXisA Date: Wed, 17 Jan 2024 03:48:43 +0000 Message-ID: <74EA538A-5857-4CEC-8B70-1AD4AF69994C@ebay.com> References: <20231110205128.GB1315705@nathanxps13> <20231110231150.fjm77gup2i7xu6hc@alap3.anarazel.de> <20231111023813.GB1408159@nathanxps13> <20231111024839.op2d2id33x777mll@alap3.anarazel.de> <20231111025529.GA1409540@nathanxps13> <20231127210030.GA140335@nathanxps13> In-Reply-To: <20231127210030.GA140335@nathanxps13> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=ebay.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: IA1PR07MB9829:EE_|SA1PR07MB8426:EE_ x-ms-office365-filtering-correlation-id: ef0c46eb-97a8-4d09-81d3-08dc170f3358 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 7egaFy8ZR6rmy7Zu+f15VaxWdT7yDBauGBBM7ZcufM4Bu+xUEIYKlfpYEcpF/B/OQT2BStyZpMN2YB2WM9w9OTurWJG3WXW8qAxk4izSiySxwXtmj/qSuJPDDJVmY/eoK4xemiisXsWHEmZmEzKhzQpfV6EkrqEQVMfoqZMX0inwQHIfyNVGLuiE0qZhtOGo4uhQobrixT3SvggRKcAQ4+MMNbhbckRIlMWmWS4iFTTXhd064BlabWnI+dt6IqWTjrj/N+FK4Gln5ElC8vrH4CGT/6+QZesfWd7QQfOGyZ+utgk9AedqL10Yj6b1G9gDCrJi9K/szQ9bMkPlR48VesgiWUGdNopPpT7YtSH/Sg5rbZ036h2Lhq5bix+VF8vqLsNl6CjQ7hSp+Y0sEvgwl2JWKKBiDnp04Kt/YzhDAI9Jn00hMpyrz7iSoPVNz7XQONzWGuVYUyMhW1sIua/HZgiOEI/jPyMB+YPbnoZbK+S4w4bZJ5WIpFr33zl2+Oi1OzpZSG8a14B2sAFOrn/syjx0uHu6TeE05oZBbMXVm5JwBtuJGmsUXEtwJktOrTrOP7XRuFWYyUJazkG7Wv1NpHfvLUloFyuwkY3ISBZXbyBXMm4M5DhpOhXeA7ZBJB9fTjsyPn9fyiIAWNDbtsdBp13i3wfyyvCBUx0RUH0T1L3ctfcG9jx3Hp+gxsEnxs6a x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:IA1PR07MB9829.namprd07.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(39860400002)(346002)(136003)(396003)(366004)(376002)(230922051799003)(230273577357003)(230173577357003)(1800799012)(64100799003)(186009)(451199024)(6512007)(6506007)(26005)(71200400001)(53546011)(2616005)(3480700007)(38100700002)(33656002)(36756003)(86362001)(38070700009)(82960400001)(2906002)(41300700001)(4326008)(966005)(6486002)(122000001)(5660300002)(83380400001)(76116006)(10290500003)(316002)(478600001)(6916009)(64756008)(66946007)(8936002)(91956017)(66446008)(8676002)(54906003)(66556008)(66476007)(45980500001);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?MENtSlR1dnJ4dS81UU9GdWkvcVp4aml6QzFRbXdNUjFROUpHUnlYM1g4dWtj?= =?utf-8?B?V2twcm9YL2dwdkJDeVo4Y2NCQWV4QnphckFNOFNsUTRoc3BNclpsRWVOeDdS?= =?utf-8?B?bjAzalE3Sm5tcGcrdVN1QkpXWTFsOExLL1lNZ2FHbXRkV1ZXamZSMlpYUHEr?= =?utf-8?B?bjhBVVR1TWtwSHJRNFhOaEZ0WnRObFNKNXBpZXJtUjd0eGFqREpEMnBGcldV?= =?utf-8?B?WENVaEJJTUUrd21SNWdEQmhkL1ZYcDR1bFRTVHQ1MDl4UzF2Rm1scGpJMmVX?= =?utf-8?B?OUt3blZnRy85TWM3eU9wQ3BvditBLzkyMVpMVHpINVNBdktQRnozUkhiM0Nw?= =?utf-8?B?RjVLT2tlellRRllsRk0zeHZhL3BQR3lBSmpncUN6NlVYOG5rQUpYOW5DY0Z1?= =?utf-8?B?WkxOTWxHK0NoelRRL1BtR1hrMElkVEw2Q2szdnBVSUVKZW5HNm05RnZtMWc0?= =?utf-8?B?bUp5Mm4rdkFqZmNPMC9FcGJxK0lKRnNjdDBlampyTlhyek9oaDN5d1RVVVEw?= =?utf-8?B?WUswazRtMEZyQ2s3WFZCSlhEZi9XaDhFV202MEJ2WEVnREI3cFZnSk1iVm1M?= =?utf-8?B?MktIUE1XZXVYT0ZOZmduSUQ3UkdhTk8xOEl1ay94NnVpRUg5M2lscmRzSVBJ?= =?utf-8?B?enZvS1hyMnlvM0tOMEJPMXBKdUtHRnlDTVhEa2JXY3JWTnhUcHp2Q0Q3QmFY?= =?utf-8?B?WEhORUJ1M213NXBHc1lmcDZHSWN1MmJEU216MncvemtoRVhyUEliNlBHMXFH?= =?utf-8?B?SXRsZ2NCcWMyUXhnbUR0N2ZjS0Z1YnlDNFpxdWM1MU5LdVYveDdqMkRNb1Zm?= =?utf-8?B?VE5VRTMwR2JXamR3bG9MMk5lSnFIZi9hMUZ3QU1VbjBCZUhlQ3VLMWtJNnZy?= =?utf-8?B?cUN6dmYxaUxUaDVjZ2NzQ0ZOZXJQZWNRUHdISVhpKzA4QjhKMXA4NnV1OW9k?= =?utf-8?B?NnFNTnB3QS83V21takNab2d1MVkyQmhERkFIbkRmc2VyMmR6UGc0QWZvWTQw?= =?utf-8?B?Wk9McmlCSjBJUmxSVjh2QnNqUGF4Wjk0NE5kQUNPMHIwTzdxMDNTaW04WXlH?= =?utf-8?B?cTVQTzNiSExiNDQzOC8yWHRza2wxTW9GbWp4dHc1THJzRzN3ZDNnWGpYK2tO?= =?utf-8?B?eWJacjFqS1libGxlSnYySFozTXJVRWcySWlKY3M3OWlkT1hxeFdUbU03TExH?= =?utf-8?B?UjdycUhJQkQ0aHFpZ0VXRzA4NXQyMkFoUjhZWjY3RmVsaGc1RXBDRUlvaUhB?= =?utf-8?B?dEltNVRiakhaWERyMEs5V1lWWS9aY1JCRytmeVM3eDMvcmhIRE1hVzJ0YWtU?= =?utf-8?B?QUpiOHdxUEVZSnp0ajhzT1Y0d3c3VGlSM3RZTW9WTlBBa1h3aEg5SXZzSjRU?= =?utf-8?B?MmhMSExkamo1RWRVUG8wcjRTUDV4OElJckdCQ3UxRlIreGFIV1lqSFBzcS9x?= =?utf-8?B?VXltbElBL0ZaL1h4eS9uclNZN1hWTHVaSTEvcGNQOXVkZXNKT2VmQkFzaHBV?= =?utf-8?B?ejNUTHVXMmxQL3F3bFUvY1lpSDF0QzBlQmtlRSs3UTdKUWFHN3ovMzZRdmJT?= =?utf-8?B?aFBpcnJLK1AyNW91ZDF6SWtJNHZTMVhOSkkzOFFKOUwva2hrR2NCUiswWE4y?= =?utf-8?B?M0tiN2R3dkoxNWVDVGQxUkZRb3UzelNNR0tmYW9jL3pMZkdzenMzM3gyZzJE?= =?utf-8?B?VVdPSXMwd25PZ2VuK2tDK0ZydU4wMVlvS2ZYQVhJL1VvcFhqVTA0WWp0Uzky?= =?utf-8?B?bEtIUW5tR0FjOGNzWXJyOW5qVytib0NrR3UxN0RJQzRsaVdxTWtWeTZJYlhL?= =?utf-8?B?UE5SNGt4SlcyZ3pCaWlNQXF4MTV0cjJEMG13dXBISHBZNkp2LzJJK2RrZXNT?= =?utf-8?B?YjM4OWxka3d3UDZwWUxGQ2NObG5RbUtWQXM5RFQ3SXJwb0tuUHEwelZjNW40?= =?utf-8?B?NU5acWhlZ2htT3F3Ty9iU1ZkcS9tR0RrVGlCbEdOLzQwNVB1a3BZVmtkOFU0?= =?utf-8?B?Y0pHc3k0YWdLdTBqQnRBR2luM2N6dGlxdnZ4cDFyRU1uRk5Tc2lHU1dNdWZE?= =?utf-8?B?SldDSW1qbGxNSkt1SVJqZDdqOVd3dC9xemZZU0llM2M4ZHhTSUlVSENHSE84?= =?utf-8?Q?n1XI997AForQfveaeXtec517t?= Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: ebay.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: IA1PR07MB9829.namprd07.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: ef0c46eb-97a8-4d09-81d3-08dc170f3358 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Jan 2024 03:48:43.2719 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 46326bff-9928-41a0-baca-17c16c94ea99 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 5T9ESRNmgkgP7TZN4gk1fIxFg1cAcEPWQIiZQgX55m2vD3qOjCIvM+VT0/CUaFJO X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA1PR07MB8426 X-CFilter: Scanned lvs1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk DQoNCj4gT24gTm92IDI4LCAyMDIzLCBhdCAwNTowMCwgTmF0aGFuIEJvc3NhcnQgPG5hdGhhbmRi b3NzYXJ0QGdtYWlsLmNvbT4gd3JvdGU6DQo+IA0KPiBFeHRlcm5hbCBFbWFpbA0KPiANCj4gSGVy ZSdzIGEgdjIgb2YgdGhlIHBhdGNoIHNldCBpbiB3aGljaCBJJ3ZlIGF0dGVtcHRlZCB0byBhZGRy ZXNzIGFsbA0KPiBmZWVkYmFjay4gIEkndmUgYWxzbyBhZGRlZCBhIHBnX3dyaXRlX21lbWJhcnJp ZXJfdSogcGFpciBvZiBmdW5jdGlvbnMgdGhhdA0KPiBwcm92aWRlIGFuIGVhc3kgd2F5IHRvIHdy aXRlIHRvIGFuIGF0b21pYyB2YXJpYWJsZSB3aXRoIGZ1bGwgYmFycmllcg0KPiBzZW1hbnRpY3Mu ICBJbiB0aGUgZ2VuZXJpYyBpbXBsZW1lbnRhdGlvbiwgdGhlc2UgYXJlIGp1c3QgYWxpYXNlcyBm b3IgYW4NCj4gYXRvbWljIGV4Y2hhbmdlLg0KPiANCj4gMDAwMiBkZW1vbnN0cmF0ZXMgaG93IHRo ZXNlIGZ1bmN0aW9ucyBtaWdodCBiZSB1c2VkIHRvIGVsaW1pbmF0ZSB0aGUNCj4gYXJjaF9sY2sg c3BpbmxvY2ssIHdoaWNoIGlzIG9ubHkgZXZlciB1c2VkIGZvciBvbmUgYm9vbGVhbiB2YXJpYWJs ZS4gIE15DQo+IGhvcGUgaXMgdGhhdCB0aGUgbWVtYmFycmllciBmdW5jdGlvbnMgbWFrZSBlbGlt aW5hdGluZyBzcGlubG9ja3MgZm9yDQo+IG5vbi1wZXJmb3JtYW5jZS1zZW5zaXRpdmUgY29kZSBl YXN5IHRvIHJlYXNvbiBhYm91dC4NCj4gDQo+IChXZSBtaWdodCBiZSBhYmxlIHRvIHVzZSBhIHBn X2F0b21pY19mbGFnIGluc3RlYWQgZm9yIDAwMDIsIGJ1dCB0aGF0IGNvZGUNCj4gc2VlbXMgaW50 ZW5kZWQgZm9yIGEgc2xpZ2h0bHkgZGlmZmVyZW50IHVzZS1jYXNlIGFuZCBoYXMgbW9yZSBjb21w bGljYXRlZA0KPiBiYXJyaWVyIHNlbWFudGljcy4pDQo+IA0KPiAtLQ0KPiBOYXRoYW4gQm9zc2Fy dA0KPiBBbWF6b24gV2ViIFNlcnZpY2VzOiBodHRwczovL2F3cy5hbWF6b24uY29tDQoNCkhpIE5h dGhhbiwNCg0KVGhlIHBhdGNoIGxvb2tzIGdvb2QgdG8gbWUuDQoNClRoZSBwYXRjaCBhZGRzIHR3 byBwYWlycyBvZiBhdG9taWMgZnVuY3Rpb25zIHRoYXQgcHJvdmlkZSBmdWxsLWJhcnJpZXIgc2Vt YW50aWNzIHRvIGF0b21pYyByZWFkL3dyaXRlIG9wZXJhdGlvbnMuIFRoZSBwYXRjaCBhbHNvIGlu Y2x1ZGVzIGFuIGV4YW1wbGUgb2YgaG93IHRoaXMgbmV3IGZ1bmN0aW9ucyBjYW4gYmUgdXNlZCB0 byByZXBsYWNlIHNwaW4gbG9ja3MuDQoNClRoZSBwYXRjaCBhcHBsaWVzIGNsZWFubHkgdG8gSEVB RC4g4oCcbWFrZSBjaGVjay13b3JsZOKAnSBhbHNvIHJ1bnMgY2xlYW5seSB3aXRoIG5vIGVycm9y LiAgSSBhbSBtb3ZpbmcgaXQgdG8gUmVhZHkgZm9yIENvbW1pdHRlcnMuDQoNClJlZ2FyZHMsDQpZ b25n