On Wed, 4 Jan 2023 at 23:21, Spring Zhong <spring.zh...@openpie.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/
