Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jhLBk-0007sG-If for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Jun 2020 22:51:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jhLBi-0001wd-FK for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Jun 2020 22:51:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jhLBi-0001wV-7Y for pgsql-hackers@lists.postgresql.org; Fri, 05 Jun 2020 22:51:46 +0000 Received: from mail-qk1-x743.google.com ([2607:f8b0:4864:20::743]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jhLBb-0007Wk-54 for pgsql-hackers@postgresql.org; Fri, 05 Jun 2020 22:51:45 +0000 Received: by mail-qk1-x743.google.com with SMTP id b27so11447333qka.4 for ; Fri, 05 Jun 2020 15:51:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=M+YEAthAOE+LSmqYuSAwGTDqqSne5L2q9y2bwrC0dKQ=; b=g+DsYrLVM2PIzfM81SG0wfx+5FDtPV1gRZi6lFgFYux/QXeUdIEL/nhk6uTUsqu+Bb I3cG0SyhKsUj0/pfqab1wcDsCnO+0AczOPB3qH2h+W/LutSqtlyOhYJyoOyhLdiuyBi0 4SQ+zWvHOgpzovaoqxP8QhdkafIRPRWYIXX5t2m4dR9WstqtUX3Jfa3beXixHiLHSKIt 7YPVLwDC1ew5KzAig9AO3FVqQC9UGyelqpbWF3UIvs+iTkVZ1/xmVubKBfW/hk7DHKL5 EGnkI1eYdnaVvbJTYmp6fBwy9/ppi0CJdj8bA9HSk4OIM1fVvJ2OcSiQouRd+7FqGTlq JpfA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=M+YEAthAOE+LSmqYuSAwGTDqqSne5L2q9y2bwrC0dKQ=; b=O4H+TxMDiS/FRUS5pC3M8Qa8W53AAvG3g0lSIMSsQOzjRpyskJELfX7JhqPxVsfdQR iqy+6wsT+i+VC4c44vcE7hm/prVafjt7Ha0qidxcvDkOGTWIhHu4pMW+vLPEFA3nleoZ JhMFk198xNF84erkGFB7+mtZDSp5q3gsihxOvZgOn6Q2f6XbrE+WszOzTrUKX9KUYmIJ o/fXF2iSvRQv9o5KSOdJkPPZ7mZo9BL5MycKF8p6U61fDePcnsYdw3ACKK64dym7vOSw IfP3NEu7TT0ByEwQD0n/pbjL097bM40oT3D3OkpXwfY58G+HKhsLJ32P4FP4D2MHqERW yn2g== X-Gm-Message-State: AOAM5322xbEacn7xuzcN2ESEq4/UsyluAr/eGF585LQ6mqEkr5HFQjmK IP97V/Ap+NsXRQEBunnGJImh7A== X-Google-Smtp-Source: ABdhPJw9BOVBGkB189IFaR4JZWF8Glb1R91ppH7oGSKv1GVEXIqYmmbJaRlmGYvzTU4qXqQvf+mO9g== X-Received: by 2002:a37:b847:: with SMTP id i68mr11973441qkf.431.1591397497232; Fri, 05 Jun 2020 15:51:37 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.95.18.252]) by smtp.gmail.com with ESMTPSA id l2sm1066242qth.47.2020.06.05.15.51.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 05 Jun 2020 15:51:36 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 750D1300705; Fri, 5 Jun 2020 18:51:34 -0400 (-04) Date: Fri, 5 Jun 2020 18:51:34 -0400 From: Alvaro Herrera To: Tomas Vondra Cc: Jeff Davis , Melanie Plageman , Thomas Munro , pgsql-hackers , Heikki Linnakangas Subject: Re: Trouble with hashagg spill I/O pattern and costing Message-ID: <20200605225134.GA28816@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20200605222057.iesb3mgxtseo6jqd@development> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Jun-06, Tomas Vondra wrote: > On Fri, Jun 05, 2020 at 05:19:43PM -0400, Alvaro Herrera wrote: > > > Is this patch the only thing missing before this open item can be > > considered closed? > > I've already pushed this as 4cad2534da6d17067d98cf04be2dfc1bda8f2cd0, > sorry for not mentioning it in this thread explicitly. That's great to know, thanks. The other bit necessary to answer my question is whether do we need to do anything else in this area -- if no, then we can mark the open item as closed: https://wiki.postgresql.org/wiki/PostgreSQL_13_Open_Items#Open_Issues Thanks -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services