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 1sgrN3-009Akh-20 for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Aug 2024 19:51:53 +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 1sgrN0-00Eii1-8K for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Aug 2024 19:51:50 +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 1sgrMz-00Eiht-BZ for pgsql-hackers@lists.postgresql.org; Wed, 21 Aug 2024 19:51:50 +0000 Received: from relay6-d.mail.gandi.net ([2001:4b98:dc4:8::226]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgrMw-000mQ8-2K for pgsql-hackers@postgresql.org; Wed, 21 Aug 2024 19:51:47 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id 4DD85C0005; Wed, 21 Aug 2024 19:51:38 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vondra.me; s=gm1; t=1724269899; 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; bh=ohJ4oR3peaCdHDg4gQzJXuZmPUXTzSuLfMP2zz/sh/Y=; b=kn5pS3BKsje/vaI/CCN0BxtupqxPrE4PHfgDogMXucw9KGSvXK05E0ZBpL/mWS/4QABG63 V4wlfhRp9iPvoFN30K+u7nx2TO5toVSI22EnZzQMkX8VENJCPfES+ONLrxY+qMo0X/D0ui +hWfbJN2CSArU26ML0ruYhIPFhRolzz+a9ZGcHjrq8F1V2/Glh63xwhfPjOkW70NetXlfS wOQlIjGDo5PuXufZPFkDuviOhfe8ttgjWXqjPsPE24kU7VdXczxD+lZJT8E7mNtbQjdzr0 0m0Is12XMyEchiHf5xDnVqag6LgGiW4EKa6q8+B0GC4NOFT+/z8F2T6h901+hQ== Date: Wed, 21 Aug 2024 21:51:38 +0200 Subject: Re: optimize hashjoin Message-ID: <6f690979-c477-49ee-91d2-71f676fb0b7a@email.android.com> X-Android-Message-ID: <6f690979-c477-49ee-91d2-71f676fb0b7a@email.android.com> In-Reply-To: From: Tomas Vondra To: Robert Haas Cc: bucoo , pgsql-hackers , Tom Lane Importance: Normal X-Priority: 3 X-MSMail-Priority: Normal MIME-Version: 1.0 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 X-GND-Sasl: tomas@vondra.me List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PGRpdiBkaXI9J2F1dG8nPjxkaXY+PGRpdj48ZGl2IGNsYXNzPSJlbGlkZWQtdGV4dCI+T24gQXVn IDIxLCAyMDI0IDE5OjE3LCBSb2JlcnQgSGFhcyAmbHQ7cm9iZXJ0bWhhYXNAZ21haWwuY29tJmd0 OyB3cm90ZTo8YnIgdHlwZT0iYXR0cmlidXRpb24iPjxibG9ja3F1b3RlIHN0eWxlPSJtYXJnaW46 MCAwIDAgMC44ZXg7Ym9yZGVyLWxlZnQ6MXB4ICNjY2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFleCI+ PHAgZGlyPSJsdHIiPk9uIFdlZCwgQXVnIDIxLCAyMDI0IGF0IDEyOjMx4oCvUE0gVG9tYXMgVm9u ZHJhICZsdDt0b21hc0B2b25kcmEubWUmZ3Q7IHdyb3RlOgo8YnI+CiZndDsgQW55d2F5LCBJIHRv b2sgYSBsb29rIGFuZCB0aGUgYmFzaWMgaWRlYSBpcyBzaW1wbGUgLSB3aGVuIHNodWZmbGluZwo8 YnI+CiZndDsgdHVwbGVzIGJldHdlZW4gYmF0Y2hlcyBpbiBhIGhhc2ggam9pbiwgd2UncmUgY3Vy cmVudGx5IGRlZm9ybWluZyB0aGUKPGJyPgomZ3Q7IHR1cGxlICgtJmd0O3Nsb3QpIHdlIGp1c3Qg cmVhZCBmcm9tIGEgYmF0Y2gsIG9ubHkgdG8gaW1tZWRpYXRlbHkgZm9ybSBpdAo8YnI+CiZndDsg KHNsb3QtJmd0OykgYWdhaW4gYW5kIHdyaXRlIGl0IHRvIHRoZSAiY29ycmVjdCIgYmF0Y2guCjxi cj4KCjxicj4KRG9lcyBza2lwcGluZyB0aGlzIGNhdXNlIGFueSBwcm9ibGVtIGlmIHNvbWUgYXR0 cmlidXRlcyBhcmUgdG9hc3RlZD8KPGJyPgoKPGJyPgpJIHN1cHBvc2Ugbm90LCBqdXN0IHNvbWV0 aGluZyB0byB0aGluayBhYm91dC4KPGJyPgoKPC9wPjwvYmxvY2txdW90ZT48L2Rpdj48L2Rpdj48 L2Rpdj48ZGl2IGRpcj0iYXV0byI+SSBkb24ndCBzZWUgd2h5IHdvdWxkIHRoaXMgY2F1c2UgYW55 IHN1Y2ggcHJvYmxlbXMgLSBpZiBhbnl0aGluZyBoYXMgdG8gYmUgZG9uZSB3aGVuIGZvcm1pbmcg dGhlIHR1cGxlcywgaXQgaGFkIHRvIGJlIGRvbmUgdGhlIGZpcnN0IHRpbWUuIFNodWZmbGluZyB0 dXBsZXMgdG8gYSBkaWZmZXJlbnQgYmF0Y2ggbWF5IGhhcHBlbiwgYnV0IEFGQUlLIGl0J3MgcmVh bGx5IGp1c3QgYSBjb3B5LjwvZGl2PjxkaXYgZGlyPSJhdXRvIj48YnI+PC9kaXY+PGRpdiBkaXI9 ImF1dG8iPjxkaXY+PGRpdiBkaXI9ImF1dG8iPi0tPC9kaXY+PGRpdiBkaXI9ImF1dG8iPlRvbWFz IFZvbmRyYTwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2Pg==