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 1tzzpb-009lNn-Vi for pgsql-committers@arkaria.postgresql.org; Wed, 02 Apr 2025 15:16:44 +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 1tzzpa-00EdTm-4T for pgsql-committers@arkaria.postgresql.org; Wed, 02 Apr 2025 15:16:42 +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 1tzzpZ-00EdTc-T5 for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 15:16:41 +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.96) (envelope-from ) id 1tzzpX-002zIF-10 for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 15:16:41 +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=aaVo0VblkKd691F7szy0Gpvp6JF1PXm4MM8fVPrGtHU=; b=4MUZmL2JL91RRXsiQtdlo/lvrH Lti0AUIOsqxXbnXFixohIbKb7wBVw8Yx0+wdtwuICwH8pHMjvlP3IZvSXT3VMBfqtAFVZBwKyqoH4 gWIje0cHe3GT6T4ydARzsFg4xbr3zlagtgzXPLMLOvTpQKeM7WDd3Z6Rrv/llz0VA8DHRAFvo7d77 SO/wbjkx19dwZo5lxU/5UKI7wXKOF2GTN0I37vxWBieSPBNlQXa+0hx5mD+LpyT8poR57NZD9cRXJ NdXw8h3sVbmuqbv89TpviFCv4pGMvtBjGpDyaS4R48wlZKl8LQnRaOOA9806piNF/4j8J/bRZSik6 Me34aB0w==; Received: from gemulon.postgresql.org ([72.32.157.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 1tzzpV-00GjQL-Ll for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 15:16:37 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tzzpV-002JTf-1H for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 15:16:37 +0000 Content-Type: multipart/mixed; boundary="===============1941048827838729978==" MIME-Version: 1.0 From: Tomas Vondra To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve accounting for memory used by shared hash tables X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 02 Apr 2025 15:16:37 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1941048827838729978== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBhY2NvdW50aW5nIGZvciBtZW1vcnkgdXNlZCBieSBzaGFyZWQgaGFzaCB0YWJsZXMK CnBnX3NobWVtX2FsbG9jYXRpb25zIHRyYWNrcyB0aGUgbWVtb3J5IGFsbG9jYXRlZCBieSBTaG1l bUluaXRTdHJ1Y3QoKSwKYnV0IGZvciBzaGFyZWQgaGFzaCB0YWJsZXMgdGhhdCBjb3ZlcmVkIG9u bHkgdGhlIGhlYWRlciBhbmQgaGFzaApkaXJlY3RvcnkuICBUaGUgcmVtYWluaW5nIHBhcnRzIChz ZWdtZW50cyBhbmQgYnVja2V0cykgd2VyZSBhbGxvY2F0ZWQKbGF0ZXIgdXNpbmcgU2htZW1BbGxv YygpLCB3aGljaCBkb2VzIG5vdCB1cGRhdGUgdGhlIHNobWVtIGFjY291bnRpbmcuClRodXMsIHRo ZXNlIGFsbG9jYXRpb25zIHdlcmUgbm90IHNob3duIGluIHBnX3NobWVtX2FsbG9jYXRpb25zLgoK VGhpcyBjb21taXQgaW1wcm92ZXMgdGhlIHNpdHVhdGlvbiBieSBhbGxvY2F0aW5nIGFsbCB0aGUg aGFzaCB0YWJsZQpwYXJ0cyBhdCBvbmNlLCB1c2luZyBhIHNpbmdsZSBTaG1lbUluaXRTdHJ1Y3Qo KSBjYWxsLiBUaGlzIHdheSB0aGUKU2htZW1JbmRleCBlbnRyaWVzIChhbmQgdGh1cyBwZ19zaG1l bV9hbGxvY2F0aW9ucykgYmV0dGVyIHJlZmxlY3QgdGhlCnByb3BlciBzaXplIG9mIHRoZSBoYXNo IHRhYmxlLgoKVGhpcyBhZmZlY3RzIGFsbG9jYXRpb25zIGZvciBwcml2YXRlIChub24tc2hhcmVk KSBoYXNoIHRhYmxlcyB0b28sIGFzCnRoZSBoYXNoX2NyZWF0ZSgpIGNvZGUgaXMgc2hhcmVkLiBG b3Igbm9uLXNoYXJlZCB0YWJsZXMgdGhpcyBob3dldmVyCm1ha2VzIG5vIHByYWN0aWNhbCBkaWZm ZXJlbmNlLgoKVGhpcyBjaGFuZ2VzIHRoZSBhbGlnbm1lbnQgYSBiaXQuIFNobWVtQWxsb2MoKSBh bGlnbnMgdGhlIGNodW5rcyB1c2luZwpDQUNIRUxJTkVBTElHTigpLCB3aGljaCBtZWFucyBzb21l IHBhcnRzIChoZWFkZXIsIGRpcmVjdG9yeSwgc2VnbWVudHMpCndlcmUgYWxpZ25lZCB0aGlzIHdh eS4gQWxsb2NhdGluZyBhbGwgcGFydHMgYXMgYSBzaW5nbGUgY2h1bmsgcmVtb3Zlcwp0aGlzIChp bXBsaWNpdCkgYWxpZ25tZW50LiBXZSd2ZSBjb25zaWRlcmVkIGFkZGluZyBleHBsaWNpdCBhbGln bm1lbnQsCmJ1dCB3ZSd2ZSBkZWNpZGVkIG5vdCB0byAtIGl0IHNlZW1zIHRvIGJlIG1lcmVseSBh IGNvaW5jaWRlbmNlIGR1ZSB0bwp1c2luZyB0aGUgU2htZW1BbGxvYygpIEFQSSwgbm90IGR1ZSB0 byBuZWNlc3NpdHkuCgpBdXRob3I6IFJhaGlsYSBTeWVkIDxyYWhpbGFzeWVkOTBAZ21haWwuY29t PgpSZXZpZXdlZC1ieTogQW5kcmVzIEZyZXVuZCA8YW5kcmVzQGFuYXJhemVsLmRlPgpSZXZpZXdl ZC1ieTogTmF6aXIgQmlsYWwgWWF2dXogPGJ5YXZ1ejgxQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6 IFRvbWFzIFZvbmRyYSA8dG9tYXNAdm9uZHJhLm1lPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rn ci5lcy9tL0NBSDJMMjh2SHpSYW5rc3pocXo3ZGVYVVJ4S25jeGZpcm51VzY4ekQ3K2hWQXFhUzVH UUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2Y1OTMwZjlhOThlYTY1ZDY1 OWQ0MTYwMGExMzhlNjA4OTg4YWQxMjIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL3N0b3JhZ2UvaXBjL3NobWVtLmMgICB8ICAgNCArLQpzcmMvYmFja2VuZC91dGls cy9oYXNoL2R5bmFoYXNoLmMgfCAyODEgKysrKysrKysrKysrKysrKysrKysrKysrKysrKystLS0t LS0tLS0Kc3JjL2luY2x1ZGUvdXRpbHMvaHNlYXJjaC5oICAgICAgIHwgICAzICstCjMgZmlsZXMg Y2hhbmdlZCwgMjIyIGluc2VydGlvbnMoKyksIDY2IGRlbGV0aW9ucygtKQoK --===============1941048827838729978==--