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 1oLyGN-0005Aa-2a for pgsql-committers@arkaria.postgresql.org; Thu, 11 Aug 2022 02:49:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLyGL-0008J2-QO for pgsql-committers@arkaria.postgresql.org; Thu, 11 Aug 2022 02:49:33 +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 1oLyGL-0008It-3K for pgsql-committers@lists.postgresql.org; Thu, 11 Aug 2022 02:49:33 +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 1oLyGI-0006nL-La for pgsql-committers@lists.postgresql.org; Thu, 11 Aug 2022 02:49:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=sSnsT7rHXWwh7Wux93BxsaZglTiEpo7rq+Ra6ZIW/DE=; b=i7tyzR+9go5XHsBnHjK/p31aSp 0FbtVUu+DvJBFTkvuLqw+rROp67IjZAMS9L4Zc5fdvZEpiqfmBHNvMXBhuV0reI0C/sx1p/TXbsJZ ydLIlPjlQaSMwvf4BhqcYCoepyym8fZmoCB/kHVJmr6qzKr79r9hmK5wCQvf0J1TOBbh1KczMZQcE 6YOoKfw5G5eqYZ5zu7pA/247lGQLKz37mdE2WQlucGHzBRyNoEfMK2frjGlhbv+3ayyqRWj8n4a5U +rdUaXFEyEtyIge+Ip3TR4r6l+MSDATwcctAWipFXIGlKr2VgxKSOq7ObdSMRavP2vvSDhyY5h7bo GPwHWqKQ==; 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 1oLyGH-0000Ip-D3 for pgsql-committers@lists.postgresql.org; Thu, 11 Aug 2022 02:49: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 1oLyGE-000DPC-W5 for pgsql-committers@lists.postgresql.org; Thu, 11 Aug 2022 02:49:28 +0000 Content-Type: multipart/mixed; boundary="===============3417805691481013511==" MIME-Version: 1.0 From: John Naylor To: pgsql-committers@lists.postgresql.org Subject: pgsql: Optimize xid/subxid searches in XidInMVCCSnapshot(). X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 11 Aug 2022 02:49:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3417805691481013511== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 T3B0aW1pemUgeGlkL3N1YnhpZCBzZWFyY2hlcyBpbiBYaWRJbk1WQ0NTbmFwc2hvdCgpLgoKQXMg cmVwb3J0ZWQgYnkgWXVyYSBTb2tvbG92LCBzY2FubmluZyB0aGUgc25hcHNob3QtPnhpcCBhcnJh eSBoYXMKbm90aWNlYWJsZSBpbXBhY3Qgb24gc2NhbGFiaWxpdHkgd2hlbiB0aGVyZSBhcmUgYSBs YXJnZSBudW1iZXIgb2YKY29uY3VycmVudCB3cml0ZXJzLiBVc2UgdGhlIG9wdGltaXplZCAob24g eDg2LTY0KSByb3V0aW5lIGZyb20gYjZlZjE2NzU2CnRvIHNwZWVkIHVwIHNlYXJjaGVzIHRocm91 Z2ggdGhlIFtzdWJdeGlwIGFycmF5cy4gT25lIGJlbmNobWFyayBzaG93ZWQKYSA1JSBpbmNyZWFz ZSBpbiB0cmFuc2FjdGlvbiB0aHJvdWdocHV0IHdpdGggMTI4IGNvbmN1cnJlbnQgd3JpdGVycywK YW5kIGEgNTAlIGluY3JlYXNlIGluIGEgcGF0aG9sb2dpY2FsIGNhc2Ugb2YgMTAyNCB3cml0ZXJz LiBXaGlsZSBhIGhhc2gKdGFibGUgd291bGQgaGF2ZSBzY2FsZWQgZXZlbiBiZXR0ZXIsIGl0IHdh cyB1bHRpbWF0ZWx5IHJlamVjdGVkIGJlY2F1c2UKb2YgY29uY2VybnMgYXJvdW5kIGNvZGUgY29t cGxleGl0eSBhbmQgbWVtb3J5IGFsbG9jYXRpb24uIENyZWRpdCB0byBBbmRyZXMKRnJldW5kIGZv ciB0aGUgaWRlYSB0byBvcHRpbWl6ZSBsaW5lYXIgc2VhcmNoIHVzaW5nIFNJTUQgaW5zdHJ1Y3Rp b25zLgoKTmF0aGFuIEJvc3NhcnQKClJldmlld2VkIGJ5OiBBbmRyZXMgRnJldW5kLCBKb2huIE5h eWxvciwgQmhhcmF0aCBSdXBpcmVkZHksIE1hc2FoaWtvIFNhd2FkYQpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tLzIwMjIwNzEzMTcwOTUwLkdBMzExNjMxOCU0MG5hdGhhbnhwczEzCgpC cmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVz cWwub3JnL3BnL2NvbW1pdGRpZmYvMzdhNmU1ZGYzNzEzNDk4YTIxOTQyZGFlMmVkMzEyMmJiYTVi OWY1MAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvdGlt ZS9zbmFwbWdyLmMgfCAyOCArKysrKysrLS0tLS0tLS0tLS0tLS0tLS0tLS0tCjEgZmlsZSBjaGFu Z2VkLCA3IGluc2VydGlvbnMoKyksIDIxIGRlbGV0aW9ucygtKQoK --===============3417805691481013511==--