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.96) (envelope-from ) id 1vlBte-008h5U-2V for pgsql-admin@arkaria.postgresql.org; Wed, 28 Jan 2026 20:12:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlBtb-003N2y-2U for pgsql-admin@arkaria.postgresql.org; Wed, 28 Jan 2026 20:12:12 +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.96) (envelope-from ) id 1vlBtb-003N2q-16 for pgsql-admin@lists.postgresql.org; Wed, 28 Jan 2026 20:12:11 +0000 Received: from mail-43103.protonmail.ch ([185.70.43.103]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vlBtZ-00000000vqp-1Bfw for pgsql-admin@lists.postgresql.org; Wed, 28 Jan 2026 20:12:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.ch; s=protonmail3; t=1769631127; x=1769890327; bh=32GGysPq2NDORnaKHWOrPYYdir/JHQR4HcXBqkRGEgs=; h=Date:To:From:Subject:Message-ID:Feedback-ID:From:To:Cc:Date: Subject:Reply-To:Feedback-ID:Message-ID:BIMI-Selector; b=nBB5mCOJLChXkEVSONBNkBfKCQLNSg61vHmYBuMPXMqMLYIyIsr9ato8qb24+87Du +oKp2foQFz2Mw/Iv2sWc0SvjAHt+vMKbRi2+aJAvprnjYMv3ho1X9W9zZ//F9gJgNj D8c0eLb8j+EOhV2FmU9KY8Nxj4iQZZq8vSNaCFrCglRIdk+PyMG4OJ+QSq17m5sW9h S4zSE88XqW955t14VlGTAcuhmNbmu8V+CtIoHKieu99DZ0LjD4vMfEjN+GpaKS9zhh 2ZoBirUFFSd4Z6ZKTI4yq1r9JZpfzRiPtirPM0aQobQ1Ahv6oVp8QJII5v54cxSkD/ gUqMbIA10n40Q== Date: Wed, 28 Jan 2026 20:12:01 +0000 To: "pgsql-admin@lists.postgresql.org" From: Tim Herren Subject: Maximum amount of pg_locks Message-ID: Feedback-ID: 17062862:user:proton X-Pm-Message-ID: 612c7a57d81d89b245b506b18e809ebda2a3f3da MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="b1=_0jrxldBRQ4RsxGQ6aRTYyfmJ0WyVkmxsUkHvUSKI" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --b1=_0jrxldBRQ4RsxGQ6aRTYyfmJ0WyVkmxsUkHvUSKI Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 SGkKCkknbSB0cnlpbmcgdG8gd3JhcCBteSBoZWFkIGFyb3VuZCB0aGUgd2F5IHRoZSBjYWxjdWxh dGlvbiBmb3IgdGhlIG1heGltdW0gYW1vdW50IG9mIGxvY2tzIHdvcmtzIGluIHBvc3RncmVzIDE2 LjExCkkgYWxyZWFkeSBjYW1lIHRvIHRoZSB1bmRlcnN0YW5kaW5nIHRoYXQgdGhlIG1heGltdW0g YW1vdW50IG9mIGxvY2tzIGFyZSBub3Qgb24gYSB0cmFuc2FjdGlvbiBiYXNpcywgYnV0IHJhdGhl ciBpbmZsdWVuY2VkIGJ5IHRoZSBzZXR0aW5nICJtYXhfbG9ja3NfcGVyX3RyYW5zYWN0aW9uIiBh bmQgdGhlICJtYXhfY29ubmVjdGlvbnMiLgpJJ20gc2F5aW5nIGluZmx1ZW5jZWQgcmF0aGVyIHRo YW4gY2FsY3VsYXRlZCBiZWNhdXNlIG9uIG15IHNlcnZlciBhIHNpbXBsZSBtdWx0aXBsaWNhdGlv biBvZiB0aG9zZSB0d28gdmFsdWVzLCBzZXQgYXQgNTEyIGFuZCAxODAgcmVzcGVjdGl2ZWx5IGdp dmVzIDkyMTYwLgoKWWV0IEkgcmVndWxhcmx5IG9ic2VydmUgYXJvdW5kIDExOWsgbG9ja3MgZHVy aW5nIG15IGJhY2t1cCB1c2luZyAicGdfZHVtcCAtRmMiLgoKcG9zdGdyZXM9IyBTRUxFQ1QKbG9j a3R5cGUsCm1vZGUsCmNvdW50KCopCkZST00gcGdfbG9ja3MKR1JPVVAgQlkgMSwgMgpPUkRFUiBC WSAzIERFU0M7CmxvY2t0eXBlIHwgbW9kZSB8IGNvdW50Ci0tLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0tLS0tLSstLS0tLS0tLQpyZWxhdGlvbiB8IEFjY2Vzc1NoYXJlTG9jayB8IDExOTk0OAp2aXJ0 dWFseGlkIHwgRXhjbHVzaXZlTG9jayB8IDIKKDIgcm93cykKClRoZSBkYXRhYmFzZSBJJ20gYmFj a2luZyB1cCBhdCB0aGF0IHRpbWUgY29udGFpbnMgMjQyIHNjaGVtYXMgYW5kIGVhY2ggaGFzIGFy b3VuZCA1MDAgcmVsYXRpb25zIChhIG1peCBvZiB0YWJsZXMgYW5kIHNlcXVlbmNlcykuClNvIHRo YXQgbWF0Y2hlcyBwcmV0dHkgd2VsbC4KCkkndmUgdmVyaWZpZWQgdGhhdCBteSBjb25maWd1cmVk IHNldHRpbmcgaXMgZW5vdWdoIGluIHRoZSBzZW5zZSB0aGF0IEkgZ2V0IGEgdXNhYmxlIGJhY2t1 cCBhbmQgbXkgZGF0YWJhc2UgcmVtYWlucyBvcGVyYXRpb25hbCBkdXJpbmcgdGhlIGJhY2t1cCBw ZXJpb2QuIE5vbiB0aGUgbGVzcyBJIHdvdWxkIGxpa2UgdG8gdW5kZXJzdGFuZCB3aGVyZSB0aGF0 IGRpZmZlcmVuY2UgY29tZXMgZnJvbSBhbmQgaG93IGNsb3NlIHRvIHRoZSAiYWN0dWFsIGxpbWl0 IiBJIGFtLgpQbGVhc2UgbGV0IG1lIGtub3cgaWYgdGhpcyBuZWVkcyBtb3JlIGluZm9ybWF0aW9u LgpUaGFua3M= --b1=_0jrxldBRQ4RsxGQ6aRTYyfmJ0WyVkmxsUkHvUSKI Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6IEFyaWFsLCBzYW5zLXNlcmlmOyBmb250LXNpemU6IDE0 cHg7Ij48c3Bhbj5IaTwvc3Bhbj48ZGl2Pjxicj48L2Rpdj48ZGl2PjxzcGFuPkknbSB0cnlpbmcg dG8gd3JhcCBteSBoZWFkIGFyb3VuZCB0aGUgd2F5IHRoZSBjYWxjdWxhdGlvbiBmb3IgdGhlIG1h eGltdW0gYW1vdW50IG9mIGxvY2tzIHdvcmtzIGluIHBvc3RncmVzIDE2LjExPC9zcGFuPjwvZGl2 PjxkaXY+PHNwYW4+SSBhbHJlYWR5IGNhbWUgdG8gdGhlIHVuZGVyc3RhbmRpbmcgdGhhdCB0aGUg bWF4aW11bSBhbW91bnQgb2YgbG9ja3MgYXJlIG5vdCBvbiBhIHRyYW5zYWN0aW9uIGJhc2lzLCBi dXQgcmF0aGVyIGluZmx1ZW5jZWQgYnkgdGhlIHNldHRpbmcgIm1heF9sb2Nrc19wZXJfdHJhbnNh Y3Rpb24iIGFuZCB0aGUgIm1heF9jb25uZWN0aW9ucyIuPC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4+ SSdtIHNheWluZyBpbmZsdWVuY2VkIHJhdGhlciB0aGFuIGNhbGN1bGF0ZWQgYmVjYXVzZSBvbiBt eSBzZXJ2ZXIgYSBzaW1wbGUgbXVsdGlwbGljYXRpb24gb2YgdGhvc2UgdHdvIHZhbHVlcywgc2V0 IGF0IDUxMiBhbmQgMTgwIHJlc3BlY3RpdmVseSBnaXZlcyA5MjE2MC48L3NwYW4+PC9kaXY+PGRp dj48YnI+PC9kaXY+PGRpdj48c3Bhbj5ZZXQgSSByZWd1bGFybHkgb2JzZXJ2ZSBhcm91bmQgMTE5 ayBsb2NrcyBkdXJpbmcgbXkgYmFja3VwIHVzaW5nICJwZ19kdW1wIC1GYyIuPC9zcGFuPjwvZGl2 PjxkaXY+PGJyPjwvZGl2PjxkaXY+PHNwYW4+cG9zdGdyZXM9IyBTRUxFQ1QgPC9zcGFuPjwvZGl2 PjxkaXY+PHNwYW4+Jm5ic3A7ICZuYnNwOyBsb2NrdHlwZSwgPC9zcGFuPjwvZGl2PjxkaXY+PHNw YW4+Jm5ic3A7ICZuYnNwOyBtb2RlLCA8L3NwYW4+PC9kaXY+PGRpdj48c3Bhbj4mbmJzcDsgJm5i c3A7IGNvdW50KCopIDwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuPkZST00gcGdfbG9ja3MgPC9zcGFu PjwvZGl2PjxkaXY+PHNwYW4+R1JPVVAgQlkgMSwgMiA8L3NwYW4+PC9kaXY+PGRpdj48c3Bhbj5P UkRFUiBCWSAzIERFU0M7PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4+Jm5ic3A7IGxvY2t0eXBlICZu YnNwO3wgJm5ic3A7ICZuYnNwOyAmbmJzcDttb2RlICZuYnNwOyAmbmJzcDsgJm5ic3A7IHwgY291 bnQgJm5ic3A7PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4+LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0tLS0tKy0tLS0tLS0tPC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4+Jm5ic3A7cmVsYXRpb24gJm5i c3A7IHwgQWNjZXNzU2hhcmVMb2NrIHwgMTE5OTQ4PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4+Jm5i c3A7dmlydHVhbHhpZCB8IEV4Y2x1c2l2ZUxvY2sgJm5ic3A7IHwgJm5ic3A7ICZuYnNwOyAmbmJz cDsyPC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4+KDIgcm93cyk8L3NwYW4+PC9kaXY+PGRpdj48YnI+ PC9kaXY+PGRpdj48c3Bhbj5UaGUgZGF0YWJhc2UgSSdtIGJhY2tpbmcgdXAgYXQgdGhhdCB0aW1l IGNvbnRhaW5zIDI0MiBzY2hlbWFzIGFuZCBlYWNoIGhhcyBhcm91bmQgNTAwIHJlbGF0aW9ucyAo YSBtaXggb2YgdGFibGVzIGFuZCBzZXF1ZW5jZXMpLjwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuPlNv IHRoYXQgbWF0Y2hlcyBwcmV0dHkgd2VsbC48L3NwYW4+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRp dj48c3Bhbj5JJ3ZlIHZlcmlmaWVkIHRoYXQgbXkgY29uZmlndXJlZCBzZXR0aW5nIGlzIGVub3Vn aCBpbiB0aGUgc2Vuc2UgdGhhdCBJIGdldCBhIHVzYWJsZSBiYWNrdXAgYW5kIG15IGRhdGFiYXNl IHJlbWFpbnMgb3BlcmF0aW9uYWwgZHVyaW5nIHRoZSBiYWNrdXAgcGVyaW9kLiBOb24gdGhlIGxl c3MgSSB3b3VsZCBsaWtlIHRvIHVuZGVyc3RhbmQgd2hlcmUgdGhhdCBkaWZmZXJlbmNlIGNvbWVz IGZyb20gYW5kIGhvdyBjbG9zZSB0byB0aGUgImFjdHVhbCBsaW1pdCIgSSBhbS48L3NwYW4+PC9k aXY+PGRpdj48c3Bhbj5QbGVhc2UgbGV0IG1lIGtub3cgaWYgdGhpcyBuZWVkcyBtb3JlIGluZm9y bWF0aW9uLjwvc3Bhbj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48c3Bhbj5UaGFua3M8L3NwYW4+PGJy PjwvZGl2Pg0KPGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6IEFyaWFsLCBzYW5zLXNlcmlmOyBmb250 LXNpemU6IDE0cHg7IiBjbGFzcz0icHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2sgcHJvdG9ubWFp bF9zaWduYXR1cmVfYmxvY2stZW1wdHkiPg0KICAgIDxkaXYgY2xhc3M9InByb3Rvbm1haWxfc2ln bmF0dXJlX2Jsb2NrLXVzZXIgcHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2stZW1wdHkiPg0KICAg ICAgICANCiAgICAgICAgICAgIDwvZGl2Pg0KICAgIA0KICAgICAgICAgICAgPGRpdiBjbGFzcz0i cHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2stcHJvdG9uIHByb3Rvbm1haWxfc2lnbmF0dXJlX2Js b2NrLWVtcHR5Ij4NCiAgICAgICAgDQogICAgICAgICAgICA8L2Rpdj4NCjwvZGl2Pg0K --b1=_0jrxldBRQ4RsxGQ6aRTYyfmJ0WyVkmxsUkHvUSKI--