Re: Asynchronous Append on postgres_fdw nodes. - Mailing list pgsql-hackers

From Andrey V. Lepikhov
Subject Re: Asynchronous Append on postgres_fdw nodes.
Date
Msg-id dc214e8f-96bc-a6c0-19ba-0dffc2051b34@postgrespro.ru
Whole thread Raw
In response to Re: Asynchronous Append on postgres_fdw nodes.  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: Asynchronous Append on postgres_fdw nodes.  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List 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
https://postgrespro.com


Attachment

pgsql-hackers by date:

Previous
From: Mark Wong
Date:
Subject: Re: doc examples for pghandler
Next
From: Tom Lane
Date:
Subject: Re: create database with template doesn't copy database ACL