On Wed, 4 Jan 2023 at 23:21, Spring Zhong <spring.zhong@openpie.com> wrote:
> The plan is apparently inefficient, since the hash aggregate goes after the Cartesian product. We could expect the
query'sperformance 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/