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 1v6VQ2-005dpP-Qj for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Oct 2025 14:45:30 +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 1v6VQ0-00ApnF-B6 for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Oct 2025 14:45:29 +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.94.2) (envelope-from ) id 1v6VQ0-00Apn7-1J for pgsql-hackers@lists.postgresql.org; Wed, 08 Oct 2025 14:45:28 +0000 Received: from mail-ej1-x62d.google.com ([2a00:1450:4864:20::62d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v6VPy-0013H5-19 for pgsql-hackers@postgresql.org; Wed, 08 Oct 2025 14:45:28 +0000 Received: by mail-ej1-x62d.google.com with SMTP id a640c23a62f3a-afcb7ae6ed0so1239497766b.3 for ; Wed, 08 Oct 2025 07:45:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1759934725; x=1760539525; darn=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=e7rujrgMIb4YmzFfjesuDwYqo6nCbSeQ7HjOIHHvlPw=; b=gpS67b6ZlodIydm8T9/Qba0+WhDvVDfn5hyMaem4BT6N9sF5QvmuxIAwN5axJvhLW5 lAiy03oS2iRVMni2wSZiAMcZYoYIauwVFNpgHwyQdQWw7kvA3HmzWyqmou4JIe/4rJ7c bdvh30RvJMIkV+VDc+l5tblhpAFQOt61QfLbJSJQvrxo5oC9EubbvHlGh+ClO4Fdib/b +hGa1vdH+vZCeMl5OkZrrT3iCfO3Zg83h0srtZfnRyEu5qtlIRT73IXBtd6mX9gQwimV PNveHmbM7qHeLJm0q5n22tA62feTy221Ok9yIWqCPbcC0Zw+qwa9ftAUs5jLrtdfVUcJ 4ZvA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759934725; x=1760539525; 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=e7rujrgMIb4YmzFfjesuDwYqo6nCbSeQ7HjOIHHvlPw=; b=MBhL0Sjs3x/KUcCLuwspW8n94rz1aSfMtXka4Z/Ojj5Whu+J9XSgx91AFeBbkyGdYN HuYMh5MvthHgjSxf+wKZhRZxpQGfa92kr2b57KIiIKkix0gJIaAbmbiBrKoR1eXQE2G4 IysiDN8jhnLosq9jSqE/1FmqXUC3VPlUwCBUXuRpWu1EBdHARBTXUwdDV6NWmwYBgQWf mxgD3lo/8hMINgAeQlnhl7m6d4Cdb8R9WubXkjGpRPSlKWfJuTv7P2LJf1or0hju7a20 RUVA/Fhiin/G8+ZrVrLCTLWLVTA1iVcqJzcXNxNHFdzR1loZhVDNm3MERn3ws2xMHTF+ HXzw== X-Forwarded-Encrypted: i=1; AJvYcCUBCyIFK0Vq3ux/9t2IwVhthy/vPlXQNhXpWtH3SPjPsfQEPkx+TNIlD3lAsde3b0aXYgkEPIOWA5lOgUy0@postgresql.org X-Gm-Message-State: AOJu0YwSV1D6HPUicHfBGhLWHZBcuKjmJH6BYm/W/e+eefEJpkYy1wOu 8lqAmllOV1tnkDMKKh6NXL0PgeX3ziYRgDKZ1AZ2RJkOO3jumjM0JcdfgZ46jqprtj7y9GxzAPn eIbaWCT5ta1qddoqoLgyF1PHeVdF0NMw= X-Gm-Gg: ASbGncvLhMgWnaxUU0GM9cBDUM9FBZkmcGa+PUuoVUO9GEE4bdav7KGU9Zp1PHfHyfu J6xmfruNH5oQPaGuSTEUbpBM3gldjp9A/m2xOzD8zd4OyzyE8LtCMtS6H4MzKm5UiIgljxKtLiV tYb1zjKdqhS7tRCTKUFTDxc28pzJ166cALHvTHKUL+PjU+SnbxgmQB3+zbKww+nZlHglgE8Xg0D 8N4fuMHnIFBXMCjPABSxf2g4U6E6jFP6o5XebHuiw== X-Google-Smtp-Source: AGHT+IHbTo42EAKVsLxi0LfquZq4o/rN8tVT02Uxuo8KMff1uq3xHaqeOX8rj+rTP4nXCEioqoxLAshb/4Okt9hhOmY= X-Received: by 2002:a17:906:c10f:b0:b3c:f0a4:b324 with SMTP id a640c23a62f3a-b50aaa9fe39mr397428166b.21.1759934724734; Wed, 08 Oct 2025 07:45:24 -0700 (PDT) MIME-Version: 1.0 References: <87il22cj51.fsf@163.com> In-Reply-To: From: Robert Haas Date: Wed, 8 Oct 2025 10:45:12 -0400 X-Gm-Features: AS18NWAfrQrSUFPhiRH_R7Zq4uqnkk66jzgy4MrDmJeDhw9TDslY8zLzqfzP9M8 Message-ID: Subject: Re: Eager aggregation, take 3 To: Richard Guo 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 Tue, Oct 7, 2025 at 6:57=E2=80=AFAM Richard Guo = wrote: > > 10. I don't think this comment quite makes sense: > > > > * "apply_at" tracks the lowest join level at which partial aggregation= is > > * applied. > > > > maybe "minimum set of rels to join before partial aggregation can be ap= plied"? > I've updated the comment for apply_at to clarify that it refers to the > relids at which partial aggregation is applied. > > I've also updated the comments within RelAggInfo to use one-line > style. > > 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. --=20 Robert Haas EDB: http://www.enterprisedb.com