MIME-Version: 1.0
References: 
 <CAOKkKFvYHSEsFazkrf9bRH14p-H27XMaqbZfRYjS6EHBruvZMQ@mail.gmail.com>
In-Reply-To: 
 <CAOKkKFvYHSEsFazkrf9bRH14p-H27XMaqbZfRYjS6EHBruvZMQ@mail.gmail.com>
From: Tatsuro Yamada <yamatattsu@gmail.com>
Date: Fri, 6 Jun 2025 19:03:27 +0900
Message-ID: 
 <CAOKkKFvyFZSJxtbj6Hn+htmpA55hSjJ0GThuTzHTY5=pF5Rgyg@mail.gmail.com>
Subject: Re: Add enable_groupagg GUC parameter to control GroupAggregate usage
To: pgsql-hackers@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001bf4d50636e45869"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOKkKFvyFZSJxtbj6Hn%2BhtmpA55hSjJ0GThuTzHTY5%3DpF5Rgyg%40mail.gmail.com>
Precedence: bulk

--0000000000001bf4d50636e45869
Content-Type: text/plain; charset="UTF-8"

Hi,

# Query Execution Results (Average of 3 measurements)
> - With parallel query:                                 39546 seconds
> - With parallel query and enable_groupagg turned off:   1115 seconds
>

Oops, I made a mistake. The correct execution time is:
- With parallel query:                                 39546 ms
- With parallel query and enable_groupagg turned off:   1115 ms

Regards,
Tatsuro Yamada

--0000000000001bf4d50636e45869
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div dir=3D"ltr"><br></div><div class=3D"gma=
il_quote gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"ltr"><div><div><div># Query Execution Results (Average o=
f 3 measurements)<br>- With parallel query: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 39546 seconds<br>- With parallel query and enable_groupagg turned of=
f: =C2=A0 1115 seconds</div></div></div></div></blockquote><div><br>Oops, I=
 made a mistake. The correct execution time is:</div><div>- With parallel q=
uery: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 39546 ms<br><div>- With parallel=
 query and enable_groupagg turned off: =C2=A0 1115 ms</div><div><br></div><=
/div><div>Regards,</div><div>Tatsuro Yamada</div><div><br></div></div></div=
>

--0000000000001bf4d50636e45869--