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 1wgzgZ-006XV9-0W for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Jul 2026 06:53:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wgzgW-004vtN-1z for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Jul 2026 06:53:36 +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.96) (envelope-from ) id 1wgzgW-004vtE-13 for pgsql-hackers@lists.postgresql.org; Tue, 07 Jul 2026 06:53:36 +0000 Received: from mail-oa1-x29.google.com ([2001:4860:4864:20::29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wgzgU-00000002CJJ-14G4 for pgsql-hackers@lists.postgresql.org; Tue, 07 Jul 2026 06:53:36 +0000 Received: by mail-oa1-x29.google.com with SMTP id 586e51a60fabf-4472500e25fso1647155fac.1 for ; Mon, 06 Jul 2026 23:53:33 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783407212; cv=none; d=google.com; s=arc-20260327; b=a16GcEgGtC9eX3CPo6EyMDF1tMtklytGkHbQZ3RQVj/SvfTkuEgbA2P+Vwc1gqeDdF 5h/zBOY5oW5aIBOMqi/SJ24C/NkzE1xeMCl/x1eby98knbKtcNMbj8o7G5tlOzpgGjhj uYGt632bYSpoI+vALwzEtgJJ89rp4mlsQ0E+6/WClFunEHLUd612zUfqe9fMihKfpEJQ Pv1xu3wBoMhVRIANM30uX4P58HV2IIIgNOTzTmXoIwcAW+y7rtvhFJ6aC2iV9fB/Lw/T +65YdsByuvcGkh3jSyXkJlHpb7IBl+85kLk+AzMyLFEaLvN94AwBnzbNgkWbWFX0gbod aYnQ== 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=GdBA9pGIw9wU4u5xVzjmMguGs9cxYjdrcKXZKMsyzcQ=; fh=UnLPJT2rlX/PFboviVIEgsdrMEHu89AeZv6habwhz2w=; b=BgZyVKnTjdBlyPtwaCkB/jpCl7JBM8NrqgxnWuA6CEQ4pRERQO/aDgZDze80WsuYsO SrZ1KhLvBM6cR+25SggHHoPio47hDAfOxBUbdzLRB3OSJ+6SBHKsKacF9EC/dRpDkLa7 0YenbjMOqyJeYRgMwrEp5G3os6OA/+SDNIxF+QqDfbjVe3Ggw2KJXfvuLVtJ/BAj1MaU SVspDxR9g0SOfoIgS+zHTWEAqUZblQIecntKMKN5ijO0P4U9d2G1MVhDnKXoU0JJLSXa 8qo0xnJvw1CAvRlzaUenT8oEuF0I0eL+pH5SsE6uu3MBQnihz05PItVSdzCn5idHhBV0 wNbw==; 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=1783407212; x=1784012012; 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=GdBA9pGIw9wU4u5xVzjmMguGs9cxYjdrcKXZKMsyzcQ=; b=bd5fcsT36+R9p2dohb2XV2VLGGlMOQ2er9QsqiFIM1wJBwlOnE4jwkGD434GtjyGXd dUXP8EI54UBTm5Er1XEABNYKhINNwMWws6rOVn1G12HOs5F3U0et3BCyiRwEQ2/z8sue sUNA+0Y7Uj0QzA4vc3dHKOoxaoEc16kr2cmNWq/1sieoclaQZvKbctmtlsyICG/OlySL glRp4uQNabLW2+wXqyyb8S98S9mN77ivYJgpFf/yyhlI0RobO4orhbEelGJjaEw7bVwF yiUVEAZ4q/eiTSBzQGTLG6HlNcRYLCkwAF0lTMdqrCYFUJ9KOI6rvbg9N/QDXFhZZ4ij uEgw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783407212; x=1784012012; 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=GdBA9pGIw9wU4u5xVzjmMguGs9cxYjdrcKXZKMsyzcQ=; b=am2fxS2uO/PTa+JZ9n+8zVda4isoOm1OiH1sRXPDJjvRB/+c42Sy1igKB3tmQBIq+E XyB6HzQu+k03sfIySdF23NUdDB0KgFqeLj60m/FcBiHBM4TB81pwpeT5dD7BxcTFdY7P WbNG2+tc9nyG/Jih7348Beswj7hAxBmqruR3mybw5GzJpkydwh601HL7bwmm/sFVUE6Y dVLochPQQZLEcl56rm9HX2UVw/fQcrPbv/yZNSefiqBvgNVNqRaZSSJZUMxNcPVq/GF8 bqUHrUxcOIn3chP6NoVuRGZTVr1S+2c83/IBT/QowRHiQqJ4Qa1NzHvK/i9IrAtNfWeX ii0A== X-Forwarded-Encrypted: i=1; AFNElJ/GYJdHKGR3A12C2WTUGp97UgM0vDA8mEWfSOIiddmFFhgkAWUDTORgxTIvFSv8XgGpCLYRTzBAJi/E0HjO@lists.postgresql.org X-Gm-Message-State: AOJu0YySnhREMwtmjBMnCRaqldLQJOmTRAnVE3bTuU8GTQ3aHskFJIT1 EwMT86iY5os8SPzNN+MEAJbPp44EosAxikHsPvTzDCI+ES0ZLAFYhrDyoX7Jg9Bs8uosU0hfSFL aZQn/PLiSiRSnmPU+8poxV9M07bI+D04= X-Gm-Gg: AfdE7clvwyFbogjIJH2kq8QxevaPuUrx9l7ZpVZI2du3LuRJIFb+ESOksCqE6all2xi ufCgIJvHQjKls48alS1hKp0Z8qUna+jdJQh7j5KTGKdI/UUxuxqG1wrtuyrRByEq2SS8TIuJpby 4eYddbnL84N33LfQejueYBFBVC7VmVWUJ1CGq8YUaCX9tdcZPCJPM5+T1p/wwbPOIe3jTTl/j/O zTI76jkYqBQB9ZUr07NCLVDov0+GAu7wQFOieiZjEAwma2kur/dLUcf7XCSFYVlqBt4vq9Nuw== X-Received: by 2002:a05:6871:b0a:b0:447:9dcd:ad3 with SMTP id 586e51a60fabf-451062d1c80mr2413601fac.18.1783407211921; Mon, 06 Jul 2026 23:53:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Richard Guo Date: Tue, 7 Jul 2026 15:53:20 +0900 X-Gm-Features: AVVi8CeOUbv1G2G356__W4v7z1U07xr4gFzIrxy3QwPh4UGcAf8j8i7nvu5qkkU 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 Tue, Jul 7, 2026 at 3:47=E2=80=AFPM Richard Guo = wrote: > Attached is a rebased patch to make cfbot work again. I intend to push this patch soon. That way newly added test cases can start using enable_groupagg directly. Otherwise we'll have to keep rebasing it to convert any new tests that use enable_sort to force hashed grouping. Any thoughts? - Richard