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 1mhZk8-0003UN-Kl for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Nov 2021 16:01:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mhZk7-0006JH-Az for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Nov 2021 16:01:03 +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 1mhZk6-0006J8-WF for pgsql-hackers@lists.postgresql.org; Mon, 01 Nov 2021 16:01:03 +0000 Received: from smtp-fw-80007.amazon.com ([99.78.197.218]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mhZk3-0003ot-Tr for pgsql-hackers@postgresql.org; Mon, 01 Nov 2021 16:01:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1635782460; x=1667318460; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=wRUPsmb8vPp0NjUvv1jwIy0KRK+Adb6j1q2KKLDZwHM=; b=FDlzUMrEo8bMMyBuL0B10ZMwA4sFYS68YYEGiXdXbU8p9R6zRRhDFgHG CXWmwvMPPi0z/N32cFq7WBlfjCNcy2S5mPuUow3H6q1JkF9him4ZWyry+ XNp7iNUzLKD9RmGV6l8BbjNqDrElFkHpey8J36H2Chjdk0Yi3RV538DKs A=; X-IronPort-AV: E=Sophos;i="5.87,200,1631577600"; d="scan'208";a="38283358" Subject: Re: inefficient loop in StandbyReleaseLockList() Thread-Topic: inefficient loop in StandbyReleaseLockList() Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-pdx-2c-b09ea7fa.us-west-2.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP; 01 Nov 2021 16:00:56 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-pdx-2c-b09ea7fa.us-west-2.amazon.com (Postfix) with ESMTPS id 0E78241C0C; Mon, 1 Nov 2021 16:00:55 +0000 (UTC) Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Mon, 1 Nov 2021 16:00:54 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC004.ant.amazon.com (10.43.162.49) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Mon, 1 Nov 2021 16:00:54 +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; Mon, 1 Nov 2021 16:00:54 +0000 From: "Bossart, Nathan" To: Tom Lane CC: Michael Paquier , Andres Freund , Kyotaro Horiguchi , "sulamul@gmail.com" , "pgsql-hackers@postgresql.org" Thread-Index: AQHXy60hDCrPdFjQ0k6deEIHcwG+yKvn0BoAgAAqyoCAAP49AIAAAdgAgAAC7ID//5jmAIAAd6oAgAAIAgCAAHVEAIAAPPkAgAO9o4CAAOBBgA== Date: Mon, 1 Nov 2021 16:00:54 +0000 Message-ID: <8D394A05-1B89-42DD-96F3-BCF41016EEC7@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> <0108A03D-FF2B-4CBC-933B-E047CD975158@amazon.com> <1013797.1635709095@sss.pgh.pa.us> In-Reply-To: <1013797.1635709095@sss.pgh.pa.us> 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.162.153] Content-Type: text/plain; charset="utf-8" Content-ID: <95E29FA080D6D347AFBAA4F5AD02075C@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 T24gMTAvMzEvMjEsIDEyOjM5IFBNLCAiVG9tIExhbmUiIDx0Z2xAc3NzLnBnaC5wYS51cz4gd3Jv dGU6DQo+IFllYWgsIHRoZXJlJ3Mgbm8gZXhwZWN0YXRpb24gdGhhdCB0aGlzIGRhdGEgc3RydWN0 dXJlIG5lZWRzIHRvIGJlIGtlcHQNCj4gY29uc2lzdGVudCBhZnRlciBhbiBlcnJvcjsgYW5kIEkn bSBub3QgcmVhbCBzdXJlIHRoYXQgdGhlIGV4aXN0aW5nDQo+IGNvZGUgY291bGQgY2xhaW0gdG8g c2F0aXNmeSBzdWNoIGEgcmVxdWlyZW1lbnQgaWYgd2UgZGlkIG5lZWQgaXQuDQo+IChUaGVyZSdz IGF0IGxlYXN0IGEgc2hvcnQgd2luZG93IHdoZXJlIHRoZSBjYWxsZXIncyBoYXNoIHRhYmxlIGVu dHJ5DQo+IHdpbGwgcG9pbnQgYXQgYW4gYWxyZWFkeS1mcmVlZCBMaXN0LikNCg0KUmlnaHQuDQoN Cj4gUHVzaGVkIHRoZSBwYXRjaCBhcyBnaXZlbi4gIEkndmUgbm90IHlldCByZXZpZXdlZCBvdGhl ciBsaXN0X2RlbGV0ZV9maXJzdA0KPiBjYWxsZXJzLCBidXQgSSdsbCB0YWtlIGEgbG9vay4gIChJ IHNlZW0gdG8gcmVtZW1iZXIgdGhhdCBJIGRpZCBzdXJ2ZXkNCj4gdGhlbSB3aGlsZSB3cml0aW5n IDFjZmYxYjk1YSwgYnV0IEkgZXZpZGVudGx5IG1pc3NlZCB0aGF0IHRoaXMgY29kZQ0KPiBjb3Vs ZCBiZSBkZWFsaW5nIHdpdGggYSBsaXN0IGxvbmcgZW5vdWdoIHRvIGJlIHByb2JsZW1hdGljLikN Cg0KVGhhbmtzIQ0KDQpOYXRoYW4NCg0K