Re: Asynchronous Append on postgres_fdw nodes.

From: "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: etsuro(dot)fujita(at)gmail(dot)com, movead(dot)li(at)highgo(dot)ca, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Asynchronous Append on postgres_fdw nodes.
Date: 2020-06-15 03:51:23
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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.

Andrey Lepikhov
Postgres Professional

Attachment Content-Type Size application/x-shellscript 3.4 KB
explain_partial_aggregates_problem.txt text/plain 6.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2020-06-15 04:14:55 Re: create database with template doesn't copy database ACL
Previous Message Mark Wong 2020-06-15 03:45:17 Re: doc examples for pghandler