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.96) (envelope-from ) id 1wd01M-003oOJ-2D for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Jun 2026 06:26:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wd01L-009TnU-1R for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Jun 2026 06:26:35 +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.96) (envelope-from ) id 1wd01L-009TnM-09 for pgsql-hackers@lists.postgresql.org; Fri, 26 Jun 2026 06:26:35 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wd01I-00000000IVo-30uC for pgsql-hackers@lists.postgresql.org; Fri, 26 Jun 2026 06:26:34 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-447134764f7so443207fac.2 for ; Thu, 25 Jun 2026 23:26:32 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782455192; cv=none; d=google.com; s=arc-20260327; b=LIrwz3G+iV5AhLSE7wBOXsA6nl1DwrTmxc451XoCb6YpSnSNzzCxwFkxBzPc8KEi2Y NgZSZ99qKepwGF0Qx2gnCZD684v4cUPGMw20I51RROfp5qTrRwNx3LFYvS6ldEzsGoAI 7igN5Zl/2iQY9ZRI33audnNGbM6FFg/aJvJa6s8VZ6Jp9Hg/Pngsh67J4cL3y+oDmWpd +iPAPa8Debbqe100vqMre4tFMn+PjxpvOGls4UnBgCoIToeVJ3+jmTV5nrWlHj6DzeNz 8T2aghQ96rDrtDOLBnrjh9zGSHvG1n8I9e8c2Zh+ua38qT9ZJ2lrd5KlgYgJEU/1v40a foxQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=FTpQjKSZdmUs0jQYF4AaeryTYQgijgqwKGWApVJm3uw=; fh=PtvVXXPcxXK7PiH1JevDkwPOrUwKDzOqk/f7dO502x0=; b=l2WvLSJTm4TR79XvyZsvGOH2TmV6720Ftji796qK03HkYKGZ4msK7gIzktierYmNqo nMC3TEejsd/hGcej6K6Yxc6KLMmnmHdEnzjS16Ub2NI1kfkvE2genUyxb/tlbulKkrKc KV9ZV+CJMFMllglCgPbsOG3zantA85oGK4HIATbSQMuAA1SQJf9K06HXs73XosdIuLdW cNVlUFtzlzagaJA0h6Y+cuULbHXS2ip8LdDOdEwfVAgFtJdOq/dcEhDkOjKvRO0hiTSH h5wBhlPZLg59/k1tvIVPAnHpnalUQVIOnMMA+uRd4t8QqSqfrLyOPR/zGgSAoKP41vA3 wqhQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782455192; x=1783059992; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=FTpQjKSZdmUs0jQYF4AaeryTYQgijgqwKGWApVJm3uw=; b=rat0hjdVrphyWxc2+VzbV28U5edFn2KdIqbpkITGko9cR3Ihk8FFswhQo1UPpuIWS0 vBdW1B4/uuVd+fuK4WM/pyjlFT4OteO6788vxBci1p2hls1/qzZAP/ZL7oWXFMcmXuTo uoaLQNLAP6igOVNOl1Sk/ZCfzE45939Y6ZFHoYjtVc2WCLkSQA78QB05Rz/dJqXLtGLK qOc6LZDwNday3w0AlwoILgYiXIKpDnVvik3ED8rG3To61UyOyOQ+b1NfGwQab6IhY7zi oPLKyNUHd+tmqZIiKrjos9AKOHwlkxzatBxrORgfLHHg+BxHAKKWefFAmMtP7j37hzgF vwgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782455192; x=1783059992; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=FTpQjKSZdmUs0jQYF4AaeryTYQgijgqwKGWApVJm3uw=; b=aLrwatjA3zQ54kXZ+r+fWl1HAwWfVn0HBvLwsIdzcui/kpty2phk9CJHTKm06oD3xd NASrq5jVhdj2qeaqZAPp7YPbtIjY/o0Ul4EXzP0Pj18J1ENKOn5EWuYB7kb70Sp4v78D xAEdQ55epoY1oHxxMy3X/zbsrPBl2+Qi5t9z1h1DPkPQ/S+385LGBrVqJ/9l0w8UnT8d 8sTqhbu33aWHtlMK6h3tpnp7N893JKN4GPDHPrYfAfzhdliK8aeUnthXQ+dfiQKhl1En c3EHPWV9d+cnXd+go8y38lYgsTO93Hcf09w5K9NpdBpzyKHU5GFk+aTglcLcQKgvMXtJ JGMQ== X-Forwarded-Encrypted: i=1; AHgh+Rovl8JzTu3qMwPE9Q/rqUey39IUb0gSgrXseSAt8o0RQmOQfdCYKYVXumy5pZLujCQD3eLmVAVfnAI7jLzb@lists.postgresql.org X-Gm-Message-State: AOJu0YxyLttgUgkzKD52gbu9GdeI0K5llnNRob3BIG2YloIGM3Gcm+LE 3CGqmC0J0EppDTckrAUR15bO1X03Pas0sswwgVVAM9heoLZB9g4FkpB2LONnZHWB3E1nO2hgxz0 /UiJs0ZjCH0QF+jARF+SsU3ihTIph5Ro= X-Gm-Gg: AfdE7cnQANstrCW/+f6iYsFtgCC8bvIUmAYEzgJUFFBFwMH0iWTvGNx+m6mwxJ3ynva 7aVhCWkeOjskKEnfABikEX0AQvvYPCXF0f5v8fpRa43l7ZdDRlO1rlwsFxDqQaMREkidh0slEgP VCrnCiIJY0/r6wR7nWDkaHRNnAmCcVA9rBW4crsGsu8Qu3TFDoQKKb9/WRrNqAv/qGlJuNI+ZST IQsiZ0IWVm8RH/drtPQ+HSp4No28IxJI5Lc/njf5v9FOBSjCcwIOZLryL5b23D5DFhaWAnwrA== X-Received: by 2002:a05:6870:5489:b0:441:f960:a7d5 with SMTP id 586e51a60fabf-44811cccd06mr4123660fac.28.1782455191845; Thu, 25 Jun 2026 23:26:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Richard Guo Date: Fri, 26 Jun 2026 15:26:20 +0900 X-Gm-Features: AVVi8CduHlED9yIFXc3IuWRTa0Brz2H4OTcmeIh23JjME4SzLzStAEcDfC5fiEY Message-ID: Subject: Re: Add enable_groupagg GUC parameter to control GroupAggregate usage To: Tatsuro Yamada Cc: Tatsuro Yamada , David Rowley , Ashutosh Bapat , "pgsql-hackers@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jun 25, 2026 at 6:12=E2=80=AFPM Tatsuro Yamada wrote: > It sounds like there are several plan nodes that could be covered by this= GUC > (such as SetOp, sort-based Unique for DISTINCT, semijoin uniqueification, > and Group nodes). Do you think we should cover all of them before the pat= ch > would be considered complete enough for commit? Yeah, I think so. The v4 patch actually already did that. You can find these changes in create_setop_path(), create_unique_path(), and cost_group(). > I'd be interested to hear your thoughts on how best to proceed, and wheth= er > dividing the work into smaller pieces would make sense. It seems that the scope of the regression test changes isn't too large, so I think keeping them in one patch is fine. - Richard