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 1mgViX-0007b9-Ii for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Oct 2021 17:31:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mgViW-0006T8-G7 for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Oct 2021 17:31:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mgViW-0006Sw-4i for pgsql-hackers@lists.postgresql.org; Fri, 29 Oct 2021 17:31:00 +0000 Received: from smtp-fw-6001.amazon.com ([52.95.48.154]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mgViS-0005Nv-QM for pgsql-hackers@postgresql.org; Fri, 29 Oct 2021 17:30:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1635528657; x=1667064657; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=5o5b/jI6SkrX2FCnl5hI+lArhXdPu08ltTlR3z+LQAk=; b=nY8ESvAkLKty5FXX47zKaQTJSIBrM1mPEQGa64T9Ygdn0Zh3C70b9+Il rYYoxjJZ3W9GWak3e5FV3Y8fEgDFtRv3lT9b9NA5JmlRr+okMwtGBGo9m SwyhsiA6/v9aoLYfIN0PM2jvRiZ5OpZ24osgoERkwHT76U0w0rssjsjat 4=; X-IronPort-AV: E=Sophos;i="5.87,193,1631577600"; d="scan'208";a="152944603" Subject: Re: inefficient loop in StandbyReleaseLockList() Thread-Topic: inefficient loop in StandbyReleaseLockList() Received: from iad12-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-pdx-2c-90419278.us-west-2.amazon.com) ([10.43.8.6]) by smtp-border-fw-6001.iad6.amazon.com with ESMTP; 29 Oct 2021 17:30:55 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-pdx-2c-90419278.us-west-2.amazon.com (Postfix) with ESMTPS id BB682422BE; Fri, 29 Oct 2021 17:30:54 +0000 (UTC) Received: from EX13D03UWC003.ant.amazon.com (10.43.162.79) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Fri, 29 Oct 2021 17:30:45 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC003.ant.amazon.com (10.43.162.79) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Fri, 29 Oct 2021 17:30:45 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1497.024; Fri, 29 Oct 2021 17:30:45 +0000 From: "Bossart, Nathan" To: Michael Paquier , Andres Freund CC: Tom Lane , Kyotaro Horiguchi , "sulamul@gmail.com" , "pgsql-hackers@postgresql.org" Thread-Index: AQHXy60hDCrPdFjQ0k6deEIHcwG+yKvn0BoAgAAqyoCAAP49AIAAAdgAgAAC7ID//5jmAIAAd6oAgAAIAgCAAHVEAIAAPPkA Date: Fri, 29 Oct 2021 17:30:44 +0000 Message-ID: <0108A03D-FF2B-4CBC-933B-E047CD975158@amazon.com> References: <20211028.155751.1898631306946946681.horikyota.ntt@gmail.com> <20211028220748.6ekrl74minwq75f4@alap3.anarazel.de> <20211028221424.6wtcse3qkbf2cmqo@alap3.anarazel.de> <560364.1635459891@sss.pgh.pa.us> <565036.1635463448@sss.pgh.pa.us> <20211028235248.4kbhtcqn2hvjukbd@alap3.anarazel.de> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.160.241] Content-Type: text/plain; charset="utf-8" Content-ID: <776FF7C8A0E6B843A0457C0ECF848E12@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTAvMjgvMjEsIDExOjUzIFBNLCAiTWljaGFlbCBQYXF1aWVyIiA8bWljaGFlbEBwYXF1aWVy Lnh5ej4gd3JvdGU6DQo+IE9uIFRodSwgT2N0IDI4LCAyMDIxIGF0IDA0OjUyOjQ4UE0gLTA3MDAs IEFuZHJlcyBGcmV1bmQgd3JvdGU6DQo+PiBJIHN1c3BlY3QgdGhlIHJldmVyc2UgbG9jayBvcmRl ciByZWxlYXNlIGNvdWxkIGJlIHRhZCBmYXN0ZXIuIEJ1dCBJIHByb2JhYmx5DQo+PiB3b3VsZG4n dCBjaGFuZ2UgaXQgZWl0aGVyIC0gSSB3YXMgbW9yZSB0aGlua2luZyBvZiBzb21lIG9mIHRoZSBv dGhlciBjYXNlcw0KPj4gdGhhdCBkZWxldGVkIHRoZSBmaXJzdCBlbGVtZW50LCBoZXJlIGl0J3Mg YSBiaXQgaGFyZGVyIHRvIGtub3cgd2V0aGVyIHRoZXJlJ3MNCj4+IGEgY2hhbmNlIG9mIGEgQ0ZJ KCkgb3Igc3VjaC4NCj4NCj4gQWN0dWFsbHksIGFzIHRoZSBsaXN0IG9mIHJlY292ZXJ5IGxvY2tz IGlzIHNhdmVkIGluIFRvcE1lbW9yeUNvbnRleHQsDQo+IHdvdWxkbid0IGl0IGJlIGJldHRlciB0 byBrZWVwIGEgcGVyLWNlbGwgZGVsZXRpb24gb2YgdGhlIGxpc3QsIHdoaWNoDQo+IHdvdWxkIG1l YW4gdGhhdCB3ZSdkIGJldHRlciBkbyB0aGUgb3BlcmF0aW9uIGluIHRoZSByZXZlcnNlIG9yZGVy IHRvDQo+IG1ha2UgdGhpbmdzIGZhc3RlciB3aXRoIHRoZSBuZXcgbGlzdCBpbXBsZW1lbnRhdGlv bj8gIEJ1dCB0aGF0J3Mgd2hhdA0KPiBBbmRyZXMgcG9pbnRzIGF0IHdpdGggQ0ZJcyBpbiB0aGUg bWlkZGxlIG9mIG9uZSBsaXN0IG9mIHRoZSBoYXNoIHRhYmxlDQo+IHByb2Nlc3NlZD8NCg0KSG0u ICBJSVVDIGFueXRoaW5nIGJhZCBlbm91Z2ggdG8gY2F1c2UgdGhlIHN0YXJ0dXAgcHJvY2VzcyB0 byBicmVhaw0Kb3V0IG9mIHRoZSBTdGFuZGJ5UmVsZWFzZUxvY2tMaXN0KCkgbG9vcCB3aWxsIGFs c28gY2F1c2UgdGhlIGVudGlyZQ0KcHJvY2VzcyB0byBiZSByZXN0YXJ0ZWQuICBJJ20gbm90IHNl ZWluZyBhbnkgcmlzayBvZiByZXVzaW5nIGEgaGFsZi0NCnJlbGVhc2VkIGxvY2sgbGlzdC4gIEkg bWlnaHQgYmUgbWlzdW5kZXJzdGFuZGluZyB0aGUgY29uY2VybiwgdGhvdWdoLg0KDQpOYXRoYW4N Cg0K