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 1ss4ge-005tJq-HC for pgsql-committers@arkaria.postgresql.org; Sat, 21 Sep 2024 18:18:29 +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 1ss4gc-007lPH-50 for pgsql-committers@arkaria.postgresql.org; Sat, 21 Sep 2024 18:18:27 +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 1ss4gb-007lP9-TI for pgsql-committers@lists.postgresql.org; Sat, 21 Sep 2024 18:18:27 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ss4gY-000Nyw-Vx for pgsql-committers@lists.postgresql.org; Sat, 21 Sep 2024 18:18:26 +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=ZNoHywkJ2UPnAzEaNlwbiqS1EN5JejD73/zK3OHRW4Q=; b=BIeadrHxYwYP/Nxgf8++/w8lTh QFc0gQJQz+KzwAIFsgoXXT54YyVFY9FXRRTMo7FZztSOUU3l5meo+r40mNWI4UuqH2yzldEpNvejj 0XYJLdqlKA7bcmwZStYHBrp0uBc0DaP2EiCTf/ksBtCtg27WkNgxj4OROONhYgK/dQvrOe4ks1NCA ADw4eG1VuQN07sMwpiDNkYLGvSEmL+hQQhz1oJu8Ts/NPh67YzLxNEOLkD5oTdUHPDcZnaiiOkrWS ezcNgFPF3PzbvzqN5q73PjqAM/8F8EGZ2n3oPIouWVpuN6xmo4PdfNDWTiHoCOrwLKkh+MLoPfdWl 4DHUx6lg==; 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 1ss4gY-0017iQ-Lm for pgsql-committers@lists.postgresql.org; Sat, 21 Sep 2024 18:18:23 +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 1ss4gX-000IvX-63 for pgsql-committers@lists.postgresql.org; Sat, 21 Sep 2024 18:18:21 +0000 Content-Type: multipart/mixed; boundary="===============3599439475291480279==" MIME-Version: 1.0 From: Tomas Vondra To: pgsql-committers@lists.postgresql.org Subject: pgsql: Increase the number of fast-path lock slots X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 21 Sep 2024 18:18:21 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3599439475291480279== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW5jcmVhc2UgdGhlIG51bWJlciBvZiBmYXN0LXBhdGggbG9jayBzbG90cwoKUmVwbGFjZSB0aGUg Zml4ZWQtc2l6ZSBhcnJheSBvZiBmYXN0LXBhdGggbG9ja3Mgd2l0aCBhcnJheXMsIHNpemVkIG9u CnN0YXJ0dXAgYmFzZWQgb24gbWF4X2xvY2tzX3Blcl90cmFuc2FjdGlvbi4gVGhpcyBhbGxvd3Mg dXNpbmcgZmFzdC1wYXRoCmxvY2tpbmcgZm9yIHdvcmtsb2FkcyB0aGF0IG5lZWQgbW9yZSBsb2Nr cy4KClRoZSBmYXN0LXBhdGggbG9ja2luZyBpbnRyb2R1Y2VkIGluIDkuMiBhbGxvd2VkIGVhY2gg YmFja2VuZCB0byBhY3F1aXJlCmEgc21hbGwgbnVtYmVyICgxNikgb2Ygd2VhayByZWxhdGlvbiBs b2NrcyBjaGVhcGx5LiBJZiBhIGJhY2tlbmQgbmVlZHMKdG8gaG9sZCBtb3JlIGxvY2tzLCBpdCBo YXMgdG8gaW5zZXJ0IHRoZW0gaW50byB0aGUgc2hhcmVkIGxvY2sgdGFibGUuClRoaXMgaXMgY29u c2lkZXJhYmx5IG1vcmUgZXhwZW5zaXZlLCBhbmQgbWF5IGJlIHN1YmplY3QgdG8gY29udGVudGlv bgooZXNwZWNpYWxseSBvbiBtYW55LWNvcmUgc3lzdGVtcykuCgpUaGUgbGltaXQgb2YgMTYgZmFz dC1wYXRoIGxvY2tzIHdhcyBhbHdheXMgcmF0aGVyIGxvdywgYmVjYXVzZSB3ZSBoYXZlCnRvIGxv Y2sgYWxsIHJlbGF0aW9ucyAtIG5vdCBqdXN0IHRhYmxlcywgYnV0IGFsc28gaW5kZXhlcywgdmll d3MsIGV0Yy4KRm9yIHBsYW5uaW5nIHdlIG5lZWQgdG8gbG9jayBhbGwgcmVsYXRpb25zIHRoYXQg bWlnaHQgYmUgdXNlZCBpbiB0aGUKcGxhbiwgbm90IGp1c3QgdGhvc2UgdGhhdCBhY3R1YWxseSBn ZXQgdXNlZCBpbiB0aGUgZmluYWwgcGxhbi4gU28gZXZlbgp3aXRoIHJhdGhlciBzaW1wbGUgcXVl cmllcyBhbmQgc2NoZW1hcywgd2Ugb2Z0ZW4gbmVlZCBzaWduaWZpY2FudGx5IG1vcmUKdGhhbiAx NiBsb2Nrcy4KCkFzIHBhcnRpdGlvbmluZyBnZXRzIHVzZWQgbW9yZSB3aWRlbHksIGFuZCB0aGUg bnVtYmVyIG9mIHBhcnRpdGlvbnMKaW5jcmVhc2VzLCB0aGlzIGxpbWl0IGlzIHRyaXZpYWwgdG8g aGl0LiBDb21wbGV4IHF1ZXJpZXMgbWF5IGVhc2lseSB1c2UKaHVuZHJlZHMgb3IgZXZlbiB0aG91 c2FuZHMgb2YgbG9ja3MuIEZvciB3b3JrbG9hZHMgZG9pbmcgYSBsb3Qgb2YgSS9PCnRoaXMgaXMg bm90IG5vdGljZWFibGUsIGJ1dCBmb3Igd29ya2xvYWRzIGFjY2Vzc2luZyBvbmx5IGRhdGEgaW4g UkFNLAp0aGUgYWNjZXNzIHRvIHRoZSBzaGFyZWQgbG9jayB0YWJsZSBtYXkgYmUgYSBzZXJpb3Vz IGlzc3VlLgoKVGhpcyBjb21taXQgcmVtb3ZlcyB0aGUgaGFyZC1jb2RlZCBsaW1pdCBvZiB0aGUg bnVtYmVyIG9mIGZhc3QtcGF0aApsb2Nrcy4gSW5zdGVhZCwgdGhlIHNpemUgb2YgdGhlIGZhc3Qt cGF0aCBhcnJheXMgaXMgY2FsY3VsYXRlZCBhdApzdGFydHVwLCBhbmQgY2FuIGJlIHNldCBtdWNo IGhpZ2hlciB0aGFuIHRoZSBvcmlnaW5hbCAxNi1sb2NrIGxpbWl0LgpUaGUgb3ZlcmFsbCBmYXN0 LXBhdGggbG9ja2luZyBwcm90b2NvbCByZW1haW5zIHVuY2hhbmdlZC4KClRoZSB2YXJpYWJsZS1z aXplZCBmYXN0LXBhdGggYXJyYXlzIGNhbiBubyBsb25nZXIgYmUgcGFydCBvZiBQR1BST0MsIGJ1 dAphcmUgYWxsb2NhdGVkIGFzIGEgc2VwYXJhdGUgY2h1bmsgb2Ygc2hhcmVkIG1lbW9yeSBhbmQg dGhlbiByZWZlcmVuY2VzCmZyb20gdGhlIFBHUFJPQyBlbnRyaWVzLgoKVGhlIGZhc3QtcGF0aCBz bG90cyBhcmUgb3JnYW5pemVkIGFzIGEgMTYtd2F5IHNldCBhc3NvY2lhdGl2ZSBjYWNoZS4gWW91 CmNhbiBpbWFnaW5lIGl0IGFzIGEgaGFzaCB0YWJsZSBvZiAxNi1zbG90ICJncm91cHMiLiBFYWNo IHJlbGF0aW9uIGlzCm1hcHBlZCB0byBleGFjdGx5IG9uZSBncm91cCB1c2luZyBoYXNoKHJlbGlk KSwgYW5kIHRoZSBncm91cCBpcyB0aGVuCnByb2Nlc3NlZCB1c2luZyBsaW5lYXIgc2VhcmNoLCBq dXN0IGxpa2UgdGhlIG9yaWdpbmFsIGZhc3QtcGF0aCBjYWNoZS4KV2l0aCBvbmx5IDE2IGVudHJp ZXMgdGhpcyBpcyBjaGVhcCwgd2l0aCBnb29kIGxvY2FsaXR5LgoKVHJlYXRpbmcgdGhpcyBhcyBh IHNpbXBsZSBoYXNoIHRhYmxlIHdpdGggb3BlbiBhZGRyZXNzaW5nIHdvdWxkIG5vdCBiZQplZmZp Y2llbnQsIGVzcGVjaWFsbHkgb25jZSB0aGUgaGFzaCB0YWJsZSBnZXRzIGFsbW9zdCBmdWxsLiBU aGUgdXN1YWwKcmVtZWR5IGlzIHRvIGdyb3cgdGhlIHRhYmxlLCBidXQgd2UgY2FuJ3QgZG8gdGhh dCBoZXJlIGVhc2lseS4gVGhlCmFjY2VzcyB3b3VsZCBhbHNvIGJlIG1vcmUgcmFuZG9tLCB3aXRo IHdvcnNlIGxvY2FsaXR5LgoKVGhlIGZhc3QtcGF0aCBhcnJheXMgYXJlIHNpemVkIHVzaW5nIHRo ZSBtYXhfbG9ja3NfcGVyX3RyYW5zYWN0aW9uIEdVQy4KV2UgdHJ5IHRvIGhhdmUgZW5vdWdoIGNh cGFjaXR5IGZvciB0aGUgbnVtYmVyIG9mIGxvY2tzIHNwZWNpZmllZCBpbiB0aGUKR1VDLCB1c2lu ZyB0aGUgdHJhZGl0aW9uYWwgMl5uIGZvcm11bGEsIHdpdGggYW4gdXBwZXIgbGltaXQgb2YgMTAy NCBsb2NrCmdyb3VwcyAoaS5lLiAxNmsgbG9ja3MpLiBUaGUgZGVmYXVsdCB2YWx1ZSBvZiBtYXhf bG9ja3NfcGVyX3RyYW5zYWN0aW9uCmlzIDY0LCB3aGljaCBtZWFucyB0aG9zZSBpbnN0YW5jZXMg d2lsbCBoYXZlIDY0IGZhc3QtcGF0aCBzbG90cy4KClRoZSBtYWluIHB1cnBvc2Ugb2YgdGhlIG1h eF9sb2Nrc19wZXJfdHJhbnNhY3Rpb24gR1VDIGlzIHRvIHNpemUgdGhlCnNoYXJlZCBsb2NrIHRh YmxlLiBJdCBpcyBvZnRlbiBzZXQgdG8gdGhlICJhdmVyYWdlIiBudW1iZXIgb2YgbG9ja3MKbmVl ZGVkIGJ5IGJhY2tlbmRzLCB3aXRoIHNvbWUgYmFja2VuZHMgdXNpbmcgc2lnbmlmaWNhbnRseSBt b3JlIGxvY2tzLgpUaGlzIHNob3VsZCBub3QgYmUgYSBtYWpvciBpc3N1ZSwgaG93ZXZlci4gU29t ZSBiYWNrZW5zIG1heSBoYXZlIHRvCmluc2VydCBsb2NrcyBpbnRvIHRoZSBzaGFyZWQgbG9jayB0 YWJsZSwgYnV0IHRoZXJlIGNhbid0IGJlIHRvbyBtYW55IG9mCnRoZW0sIGxpbWl0aW5nIHRoZSBj b250ZW50aW9uLgoKVGhlIG9ubHkgc29sdXRpb24gaXMgdG8gaW5jcmVhc2UgdGhlIEdVQywgZXZl biBpZiB0aGUgc2hhcmVkIGxvY2sgdGFibGUKYWxyZWFkeSBoYXMgc3VmZmljaWVudCBjYXBhY2l0 eS4gVGhhdCBpcyBub3QgZnJlZSwgZXNwZWNpYWxseSBpbiB0ZXJtcwpvZiBtZW1vcnkgdXNhZ2Ug KHRoZSBzaGFyZWQgbG9jayB0YWJsZSBlbnRyaWVzIGFyZSBmYWlybHkgbGFyZ2UpLiBJdApzaG91 bGQgb25seSBoYXBwZW4gb24gbWFjaGluZXMgd2l0aCBwbGVudHkgb2YgbWVtb3J5LCB0aG91Z2gu CgpJbiB0aGUgZnV0dXJlIHdlIG1heSBjb25zaWRlciBhIHNlcGFyYXRlIEdVQyBmb3IgdGhlIG51 bWJlciBvZiBmYXN0LXBhdGgKc2xvdHMsIGJ1dCBsZXQncyB0cnkgd2l0aG91dCBvbmUgZmlyc3Qu CgpSZXZpZXdlZC1ieTogUm9iZXJ0IEhhYXMsIEpha3ViIFdhcnRhawpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tLzUxMGI4ODdlLWMwY2UtNGEwYy1hMTdhLTJjNmFiYjhkOWE1Y0BlbnRl cnByaXNlZGIuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYzRkNWNiNzFkMjI5MDk1YTM5ZmRh MTEyMWE3NWVlNDBlNjA2OWEyYQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jh Y2tlbmQvYm9vdHN0cmFwL2Jvb3RzdHJhcC5jICAgfCAgIDIgKwpzcmMvYmFja2VuZC9wb3N0bWFz dGVyL3Bvc3RtYXN0ZXIuYyB8ICAgNSArKwpzcmMvYmFja2VuZC9zdG9yYWdlL2lwYy9pcGNpLmMg ICAgICB8ICAgNiArKwpzcmMvYmFja2VuZC9zdG9yYWdlL2xtZ3IvbG9jay5jICAgICB8IDEyNSAr KysrKysrKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0Kc3JjL2JhY2tlbmQvc3RvcmFnZS9s bWdyL3Byb2MuYyAgICAgfCAgNDYgKysrKysrKysrKysrKwpzcmMvYmFja2VuZC90Y29wL3Bvc3Rn cmVzLmMgICAgICAgICB8ICAgMyArCnNyYy9iYWNrZW5kL3V0aWxzL2luaXQvcG9zdGluaXQuYyAg IHwgIDM0ICsrKysrKysrKysKc3JjL2luY2x1ZGUvbWlzY2FkbWluLmggICAgICAgICAgICAgfCAg IDEgKwpzcmMvaW5jbHVkZS9zdG9yYWdlL3Byb2MuaCAgICAgICAgICB8ICAxNyArKystLQo5IGZp bGVzIGNoYW5nZWQsIDIxMiBpbnNlcnRpb25zKCspLCAyNyBkZWxldGlvbnMoLSkKCg== --===============3599439475291480279==--