Re: grouping pushdown

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Spring Zhong <spring(dot)zhong(at)openpie(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: grouping pushdown
Date: 2023-01-04 19:40:59
Message-ID: CAApHDvpOSaNqZged6C-OGu5SRXHss6GsF4x+CiDtLp4-PeOizg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 4 Jan 2023 at 23:21, Spring Zhong <spring(dot)zhong(at)openpie(dot)com> wrote:
> The plan is apparently inefficient, since the hash aggregate goes after the Cartesian product. We could expect the query's performance get much improved if the HashAggregate node can be pushed down to the SCAN node.

> Is someone has suggestions on this?

I think this is being worked on. See [1].

David

[1] https://commitfest.postgresql.org/41/3764/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-01-04 19:59:11 Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable)
Previous Message Andres Freund 2023-01-04 19:35:02 Re: meson oddities