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 1v6foN-00819q-Cw for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Oct 2025 01:51:19 +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 1v6foL-00ETrP-6Z for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Oct 2025 01:51:18 +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 1v6foK-00ETrG-TA for pgsql-hackers@lists.postgresql.org; Thu, 09 Oct 2025 01:51:17 +0000 Received: from mail-yw1-x1134.google.com ([2607:f8b0:4864:20::1134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v6foI-000ldA-2S for pgsql-hackers@lists.postgresql.org; Thu, 09 Oct 2025 01:51:16 +0000 Received: by mail-yw1-x1134.google.com with SMTP id 00721157ae682-77636fb28f6so4130797b3.1 for ; Wed, 08 Oct 2025 18:51:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1759974675; x=1760579475; 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=MIhf3T5rQX8v5zVTpgL6eqos+G3qQOVWXWXMuSyNpSY=; b=hM6WpdVfDaCCrB/4ZthNSxYwryAk15w7ATu5ZsSFPcjv6vpS0+Q3goTqICV1xv3tJr FWpLde59Fh00p4OtDk0p9Sn1sgCGPqyiF+uG5/q/Wa5V9pxwYgoAzNDClkKw/GjsFcX3 H5Kx1XDa0ik0yTmi+7tjegNz5+0o7fftI7Pjs0tkqy2ytBNsj8RuP1Bn0oaWbaYcxeW9 AqFry5jIgZL42TI/xPIozNqTRCOy8pNajacTOk6YYdGAb79JH5oLNz3C0F0R3bEPwSe2 etq0opef8NDLZYSdmUm4WQTeBtIXk90JcmYcKbQnntvEwSMOtYBwSei56JnTwPN6UDWh S8XA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759974675; x=1760579475; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=MIhf3T5rQX8v5zVTpgL6eqos+G3qQOVWXWXMuSyNpSY=; b=iYYmpeH29rF0bnsQs1XSyRlX9Gri5MlOaI3INpxzXBxSOG0ROYvCeW9qr6ZFUM2Col 0HglsVrcCWwRmWTVlg1SV+371dyRa6eDGiPOmtiR9dB1U7MMvQHVUX+MZYuO7OhxzbLD FMYTBXGMI2X7RuHrSmhyUd21cBCV5wPBKove//53U/EXu9+FWMICkEHf+TVJi7XqeFIr y7CXfro4fKAYtJghlg+eBFgvWhpKMrwcyDtn6k9fTp0H8RK62VXFdOQ2RQTGCDyr+8Pd GiHiXV/peVELRTne9YrMqsuE290Vd+XmLAEvXkPO5jXUC0t8tnpSia4BcnEoQQwmGYkF 72jA== X-Forwarded-Encrypted: i=1; AJvYcCUEXfIW4ZLRRFWAVFk6fwDTgv/kWTGTrjtLHOrJ5NKRHKf01LAozEVPqGIRQPjSxTtpllPI7FABIeR+H0fz@lists.postgresql.org X-Gm-Message-State: AOJu0YzTQzHPesw8yOulKr0bNVjAx4D485nWCb8GKYa9n7qh1Ds4azwX QNYVcrUWZcqtk28WM85LTm99vOFESeX8/L/dR5djDE5oaZm4SCoWC37FiBOaSOkxZmSklcYOsoL w1jGnb1PWZ63cA+oGH6uB6D/ZXs96Sg8= X-Gm-Gg: ASbGnctfRuVSMmEci1JXngif+Cv8Bl4AE3/9Kf71owMuC25BRg6cGk8+qlhe/jxtaoX +Sul2KR2rxLX/4/zTE3y/9PCWbOBtnP/UpC86aI0oWtGahjWARZVIAIXZQ9tPS9i7yGRQLIW3U4 Izvu8zNb+7WH2inT1FMpybqtqxJsFlOIiDi3I1T8xfRHdVdn2vlVdDbO9Pm4vXK83gm9hktvCJG 50fJNOlDQIKPzOeHaJ14Cm7f6NvGZvGD53StN6lDlY= X-Google-Smtp-Source: AGHT+IGwYaUFuh1cr1AvF8lt3O6AA/afOPzmIn/kxGggy2oy4d1zrzkjM5ef4HCh5YrujXvNRlBGf51ADwbaYI7mwgQ= X-Received: by 2002:a05:690c:2c09:b0:773:a86d:7674 with SMTP id 00721157ae682-780e16d6076mr93752637b3.40.1759974674469; Wed, 08 Oct 2025 18:51:14 -0700 (PDT) MIME-Version: 1.0 References: <87il22cj51.fsf@163.com> In-Reply-To: From: Richard Guo Date: Thu, 9 Oct 2025 10:51:03 +0900 X-Gm-Features: AS18NWBct9Cle1RSGjRwTgcol9rhqJsJXM0Ma_qUOGLSTYGiqu1UYRr-D1Dr5nY Message-ID: Subject: Re: Eager aggregation, take 3 To: Robert Haas Cc: David Rowley , Tom Lane , Tender Wang , Paul George , Andy Fan , PostgreSQL-development , pgsql-hackers@lists.postgresql.org, Matheus Alcantara 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 Wed, Oct 8, 2025 at 11:45=E2=80=AFPM Robert Haas = wrote: > On Tue, Oct 7, 2025 at 6:57=E2=80=AFAM Richard Guo wrote: > > I retained the name of this field though. > For what it's worth, I also don't like that field name. I'm not sure > what to propose instead, but I don't think apply_at is very clear. This field represents the set of relids at which partial aggregation is applied. So how about naming it partial_agg_designated_relids? That feels a bit verbose, though. How about partial_agg_relids or, for brevity, agg_relids instead? - Richard