Thanks for testing, but..
At Mon, 15 Jun 2020 08:51:23 +0500, "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru> wrote in
> The patch has a problem with partitionwise aggregates.
>
> Asynchronous append do not allow the planner to use partial
> aggregates. Example you can see in attachment. I can't understand why:
> costs of partitionwise join are less.
> Initial script and explains of the query with and without the patch
> you can see in attachment.
I had more or less the same plan with the second one without the patch
(that is, vanilla master/HEAD, but used merge joins instead).
I'm not sure what prevented join pushdown, but the difference between
the two is whether the each partitionwise join is pushed down to
remote or not, That is hardly seems related to the async execution
patch.
Could you tell me how did you get the first plan?
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center