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 <pgsql-committers-owner+archive@lists.postgresql.org>)
	id 1u0UEc-001vgi-2H
	for pgsql-committers@arkaria.postgresql.org; Thu, 03 Apr 2025 23:44:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-committers-owner+archive@lists.postgresql.org>)
	id 1u0UDa-00BlY5-Sy
	for pgsql-committers@arkaria.postgresql.org; Thu, 03 Apr 2025 23:43:30 +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 <tomas@vondra.me>)
	id 1u0UDa-00BlXx-KR
	for pgsql-committers@lists.postgresql.org; Thu, 03 Apr 2025 23:43:30 +0000
Received: from relay9-d.mail.gandi.net ([2001:4b98:dc4:8::229])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <tomas@vondra.me>)
	id 1u0UDY-003Fcr-1K
	for pgsql-committers@lists.postgresql.org;
	Thu, 03 Apr 2025 23:43:30 +0000
Received: by mail.gandi.net (Postfix) with ESMTPSA id 965874327D;
	Thu,  3 Apr 2025 23:43:25 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vondra.me; s=gm1;
	t=1743723806;
	h=from:from:reply-to:subject:subject:date:date:message-id:message-id:
	 to:to:cc:cc:mime-version:mime-version:content-type:content-type:
	 content-transfer-encoding:content-transfer-encoding:
	 in-reply-to:in-reply-to:references:references;
	bh=xvS8KLARM6k3NJwP1gCaik8NgkNZqwPEn48DKwwUbG0=;
	b=B5rh84PXQ1YH8t+CeZ7n95zMQ2YcYbeRT8h+rN9BcqfrIa4F584XefsdjNj14Oi15gsYGN
	ylR7L9EhygPwUQXjhhrMwKPoLbZrpH3j3D33ZTfbuH4SH7wUSUkEkR1bErwTZUStFq3LvG
	x6Y9RU6g5cUvyf/s1c9JYwchq04ZjDF6ZaYlCgGmXlz7hMXkGGqIdaGkVE8FUZ0uQeFfZi
	KcHkcjeoBren2ZJemXr1VSEXVy3+gfs461ttwENN07hv8nGRLR17IcqfUCQHvX6VtTOcKi
	LEQBcCSaQDz3HJ8jg5TPLSu1jBp3wAuYeyYQS6GBQt9s525ERJXCOMcUuyo5iw==
Message-ID: <db61d8c1-7a27-4576-be37-740632a7e020@vondra.me>
Date: Fri, 4 Apr 2025 01:43:24 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: pgsql: Improve accounting for memory used by shared hash tables
To: David Rowley <dgrowleyml@gmail.com>,
 Tomas Vondra <tomas.vondra@postgresql.org>
Cc: pgsql-committers@lists.postgresql.org
References: <E1tzzpV-002JTf-1H@gemulon.postgresql.org>
 <CAApHDvriCiNkm=v521AP6PKPfyWkJ++jqZ9eqX4cXnhxLv8w-A@mail.gmail.com>
Content-Language: en-US
From: Tomas Vondra <tomas@vondra.me>
In-Reply-To: 
 <CAApHDvriCiNkm=v521AP6PKPfyWkJ++jqZ9eqX4cXnhxLv8w-A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-GND-State: clean
X-GND-Score: 0
X-GND-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddukeelleduucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuifetpfffkfdpucggtfgfnhhsuhgsshgtrhhisggvnecuuegrihhlohhuthemuceftddunecunecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpefvohhmrghsucggohhnughrrgcuoehtohhmrghssehvohhnughrrgdrmhgvqeenucggtffrrghtthgvrhhnpeeludegieekgfelhffgffeuvdelteetveeghfdvieekfeduudduvdfhvedufefhveenucfkphepkeeirdegledrvddvledrudelfeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpeekiedrgeelrddvvdelrdduleefpdhhvghloheplgdutddrudefjedrtddrudekngdpmhgrihhlfhhrohhmpehtohhmrghssehvohhnughrrgdrmhgvpdhnsggprhgtphhtthhopeefpdhrtghpthhtohepughgrhhofihlvgihmhhlsehgmhgrihhlrdgtohhmpdhrtghpthhtohepthhomhgrshdrvhhonhgurhgrsehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopehpghhsqhhlqdgtohhmmhhithhtvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg
X-GND-Sasl: tomas@vondra.me
List-Id: <pgsql-committers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-committers@lists.postgresql.org>
List-Owner: <mailto:pgsql-committers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-committers>
Archived-At: 
 <https://www.postgresql.org/message-id/db61d8c1-7a27-4576-be37-740632a7e020%40vondra.me>
Precedence: bulk

On 4/4/25 00:57, David Rowley wrote:
> On Thu, 3 Apr 2025 at 04:16, Tomas Vondra <tomas.vondra@postgresql.org> wrote:
>> Improve accounting for memory used by shared hash tables
> 
> I've not looked into why, but this is causing an issue in the
> join_rel_hash during add_join_rel(). See the attached script.
> 
> ERROR:  pfree called with invalid pointer 0x60a15edc44e0 (header
> 0x0000002000000008)
> 

Thanks for the report and reproducer. I'll take a look tomorrow.

-- 
Tomas Vondra