Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iZ9oa-0001Ab-Ek for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Nov 2019 08:33:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iZ9oY-0003gQ-UD for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Nov 2019 08:33:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iZ9oY-0003gB-Hb for pgsql-hackers@lists.postgresql.org; Mon, 25 Nov 2019 08:33:46 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iZ9oV-0004iU-7v for pgsql-hackers@postgresql.org; Mon, 25 Nov 2019 08:33:45 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 441CA54E; Mon, 25 Nov 2019 03:33:41 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 25 Nov 2019 03:33:41 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=pBMMtXB9jqCfQOEi9RkoZJlulL+ NDRW+ME7vI9GZCWo=; b=G3wEFX31IBupoLe6UX35xSpu5XjHj1Y3UUcD0VnQZ2m GCL8MLgaC1u1W5YLlTSuYn75zDkE9b3dj0Vg8W3EabhUe3scVvqp4x0bFLOO86et GRTyLNyjfY4NEoBeku6AG6t4EPkSrYU4f9aRi60m4mgxdkeTEJ/RrJJvdkNb7O8/ x4fV7REFNA2P9hp0I6lRQhdfsFatA9ZyHjzE2NZu4EcFqwKX+Y8Scc0zHURzRH1J wB2M0ssCVTuWCIuX342Rk5W+gMFwCJjBRGNzaN4k1U/AJolYAPdfPs+/vgZp/MFU jC6Mr+DwuRf/rBb/+SvbhxZEE7eAMltb/tTDi5RQW3A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=pBMMtX B9jqCfQOEi9RkoZJlulL+NDRW+ME7vI9GZCWo=; b=My/fkPjaysLkRbJJ+BeayN GMOItZ0YE3HVMOBhVb73TD7wOANINQpoLBlh4nNGdkJTYhVOMiUe9Q2RUoANEgb5 PIX2JtbHv7J1gAb9o50dxBKl+ZkqTWxNlnDbgf8NAXGwCtCMqhUEHDdOwdDEQWVk KBR9bw2fnSE5ZgDjhX/UGlyzSmgEZ3Qmw89gd24GXAVYwtvl/n6TW709I9VaWldx ynAwf45He6SUNHTczbiIGyvBeid/k5A/BxvXfgtHdCylbceNu7uIzm0gaRG53KZ+ ZvnSbDDq7ORCxOTmaK6wCCdq6ZZy3gam/T1/Tzc55WTCQMGJ75iF6/503BJmjRMg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudeitddgiedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 740073060057; Mon, 25 Nov 2019 03:33:38 -0500 (EST) Date: Mon, 25 Nov 2019 17:33:35 +0900 From: Michael Paquier To: Tomas Vondra Cc: Melanie Plageman , Alvaro Herrera , Hubert Zhang , hackers , Thomas Munro Subject: Re: accounting for memory used for BufFile during hash joins Message-ID: <20191125083335.GQ99720@paquier.xyz> References: <20190711154011.lmkp7jyd3e2zfcnx@development> <20190903163633.GA16230@alvherre.pgsql> <20190910134751.x64idfqj6qgt37om@development> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="L0TNCHh3fkwjpuuE" Content-Disposition: inline In-Reply-To: <20190910134751.x64idfqj6qgt37om@development> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --L0TNCHh3fkwjpuuE Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Sep 10, 2019 at 03:47:51PM +0200, Tomas Vondra wrote: > My feeling is that we should get the BNLJ committed first, and then maybe > use some of those additional strategies as fallbacks (depending on which > issues are still unsolved by the BNLJ). The glacier is melting more. Tomas, what's your status here? The patch has been waiting on author for two months now. If you are not planning to work more on this one, then it should be marked as returned with feedback? -- Michael --L0TNCHh3fkwjpuuE Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3bkd8ACgkQnvQgOdby QH0jcg/+Lb9z4CFdcKUK3vH0NY7VYykVEFukFe5KPRrzrkwwqzFCYUBHGCHfsFVb vguxaPKFcF4sDVX9GVW2xOo6kn8SXJ1KHblpd2E8bcVixhN0VwezaFm6hYoqFAOL TSQTxTAoZbAJIazp0R4GuvNDb/tfRtE632VApVMTyR/NUeVdSL4QgaAXAWTK95LJ AB5NnFQ88F+ABv13WMDAqDRdCfiNFIJyjEcqLfS576YcrV7uTC6tYU8+paqWZYyn H+XB8Ot7S4Hg6UivCzWkS/U1LD18DThVKdVsBsZEeuzxUPph3kO2MIFsE+8U9CvI Ry7/2WrS6PlVLWzHBNgQ2Ml5rlH2XUGTnChineG0w6Toh8aM25wNLHmZf/GfbQfx E0w6QOu3ZVtCQb8NNMfnt3XS+qxnh7tSejpZLj68JcBtRfWGKYlZ2nPNBp1a7IUp ef9+enqXoafmGmn6WHyce03kMrY/vmKd9ZrH61nVZn44UYx+D2R0KU2ontBafHq3 7Bj2JBy953U9Xc+ErCoipQNFsPF116wl8qZcy8odFnwlvEp1Lc/XZjviMzriljqd qirALnmGXlHwVF0MwnVzrR9OV53ClioCiIZcuNlxU2BaB1LskCGUfaH524OZdo8f e2oDtPMzqQsOyR0cb/fUOQ/aLBwx895YAMVEqjMRWC8dCWjot3A= =DenZ -----END PGP SIGNATURE----- --L0TNCHh3fkwjpuuE--