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 1u2YI9-002LwI-KJ for pgsql-committers@arkaria.postgresql.org; Wed, 09 Apr 2025 16:28:45 +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 1u2YI7-0051Zz-1J for pgsql-committers@arkaria.postgresql.org; Wed, 09 Apr 2025 16:28:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u2YI6-0051Zh-Po for pgsql-committers@lists.postgresql.org; Wed, 09 Apr 2025 16:28:43 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u2YI5-003uL7-0X for pgsql-committers@lists.postgresql.org; Wed, 09 Apr 2025 16:28:42 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u2YI4-002YYp-Kq for pgsql-committers@lists.postgresql.org; Wed, 09 Apr 2025 16:28:40 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u2YI4-003T9A-0h for pgsql-committers@lists.postgresql.org; Wed, 09 Apr 2025 16:28:40 +0000 Content-Type: multipart/mixed; boundary="===============3159160095491139678==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix performance issue in deadlock-parallel isolation test. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 09 Apr 2025 16:28:40 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3159160095491139678== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBlcmZvcm1hbmNlIGlzc3VlIGluIGRlYWRsb2NrLXBhcmFsbGVsIGlzb2xhdGlvbiB0ZXN0 LgoKV2l0aCBkZWJ1Z19kaXNjYXJkX2NhY2hlcyA9IDEsIHRoZSBydW50aW1lIG9mIHRoaXMgdGVz dCBzY3JpcHQKaW5jcmVhc2VkIGJ5IGFib3V0IGEgZmFjdG9yIG9mIDEwIGFmdGVyIGNvbW1pdCAw ZGNhNWQ2OGQuICBUaGF0J3MKY2F1c2luZyBzb21lIG9mIG91ciBidWlsZGZhcm0gYW5pbWFscyB0 byBmYWlsIHdpdGggYSB0aW1lb3V0LgoKVGhlIHJlYXNvbiBmb3IgdGhlIGluY3JlYXNlZCB0aW1l IGlzIHRoYXQgbm93IHdlIGFyZSByZS1wbGFubmluZwpzb21lIGludGVudGlvbmFsbHktbm9uLWlu bGluZWFibGUgU1FMIGZ1bmN0aW9ucyBvbiBldmVyeSBleGVjdXRpb24sCndoZXJlIHRoZSBwcmV2 aW91cyBjb2RpbmcgaGVsZCBvbnRvIHRoZSBvcmlnaW5hbCBwbGFucyB0aHJvdWdob3V0CnRoZSBv dXRlciBxdWVyeS4gIFRoZSBwcmV2aW91cyBiZWhhdmlvciB3YXMgYXJndWFibHkgcXVpdGUgYnVn Z3ksCnNvIEkgZG9uJ3QgdGhpbmsgMGRjYTVkNjhkIGRlc2VydmVzIGJsYW1lIGhlcmUuICBCdXQg d2Ugd291bGQKbGlrZSB0aGlzIHRlc3Qgc2NyaXB0IHRvIG5vdCB0YWtlIHNvIGxvbmcuCgpUbyBm aXgsIGluc3RlYWQgb2YgZm9yY2luZyBhICJwYXJhbGxlbCBzYWZlIiBsYWJlbCB2aWEgYQpub24t aW5saW5lYWJsZSBTUUwgZnVuY3Rpb24sIGFwcGx5IGl0IGRpcmVjdGx5IHRvIHRoZSBhZHZpc29y eS1sb2NrCmZ1bmN0aW9ucyBieSBtYWtpbmcgaW50ZXJuYWwtbGFuZ3VhZ2UgYWxpYXNlcyBmb3Ig dGhlbS4gIEEgc21hbGwKcHJvYmxlbSBpcyB0aGF0IHRoZSBhZHZpc29yeS1sb2NrIGZ1bmN0aW9u cyByZXR1cm4gdm9pZCBidXQgdGhpcwp0ZXN0IHdvdWxkIHJlYWxseSBsaWtlIHRoZW0gdG8gcmV0 dXJuIGludGVnZXIgMS4gIEkgY2hlYXRlZCBoZXJlIGJ5CmRlY2xhcmluZyB0aGUgYWxpYXNlcyBh cyByZXR1cm5pbmcgImludCIuICBUaGF0J3MgcGVyaGFwcyB1bmR1ZQpmYW1pbGlhcml0eSB3aXRo IHRoZSBpbXBsZW1lbnRhdGlvbiBvZiBQR19SRVRVUk5fVk9JRCgpLCBidXQgdGhhdApoYXNuJ3Qg Y2hhbmdlZCBpbiB0d2VudHkgeWVhcnMgYW5kIGlzIHVubGlrZWx5IHRvIGRvIHNvIGluIHRoZSBu ZXh0CnR3ZW50eS4gIFRoYXQgZ2V0cyB1cyBhbiBpbnRlZ2VyIDAgcmVzdWx0LCBhbmQgdGhlbiBh biBpbmxpbmUtYWJsZQp3cmFwcGVyIHRvIGNvbnZlcnQgdGhhdCB0byBhbiBpbnRlZ2VyIDEgYWxs b3dzIHRoZSByZXN0IG9mIHRoZSBzY3JpcHQKdG8gcmVtYWluIHVuY2hhbmdlZC4KCkZvciBtZSwg dGhpcyByZWR1Y2VzIHRoZSBydW50aW1lIHdpdGggZGVidWdfZGlzY2FyZF9jYWNoZXMgPSAxCmJ5 IGFib3V0IDEwMHgsIG1ha2luZyB0aGUgdGVzdCBjb21mb3J0YWJseSBmYXN0ZXIgdGhhbiBiZWZv cmUKaW5zdGVhZCBvZiBzbG93ZXIuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzEz NjE2My4xNzQ0MTc5NTYyQHNzcy5wZ2gucGEudXMKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi84Mzdj YzczYWYyOWNkOWM2MzUxNWE2ZjJhMzZmNTRkZDcwM2EzYTNmCgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpzcmMvdGVzdC9pc29sYXRpb24vc3BlY3MvZGVhZGxvY2stcGFyYWxsZWwuc3Bl YyB8IDE5ICsrKysrKysrKysrKysrKy0tLS0KMSBmaWxlIGNoYW5nZWQsIDE1IGluc2VydGlvbnMo KyksIDQgZGVsZXRpb25zKC0pCgo= --===============3159160095491139678==--