| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Aggregate Push Down - Performing aggregation on foreign server |
| Date: | 2016-08-31 07:42:14 |
| Message-ID: | CAFj8pRB6+y6R3unWOiucuiy3b10qTEYzihirCUhqU87R-ozTDA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
2016-08-31 9:00 GMT+02:00 Robert Haas <robertmhaas(at)gmail(dot)com>:
> On Wed, Aug 31, 2016 at 11:56 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
> > It is pity - lot of performance issues are related to this missing
> feature.
>
> I don't think you are being very clear about what feature you are
> talking about. The feature that Jeevan has implemented is pushing
> aggregates to the remote side when postgres_fdw is in use. The
> feature you are talking about is evidently something else, but you
> haven't really said what it is. Or not in a way that I can
> understand.
>
yes, It is not clear if FDW aggregate push down can be implemented together
with internal aggregate push down. Aggregate push down ~ try to aggregate
first when it is possible
Regards
Pavel
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-08-31 07:57:20 | Replace use malloc() & friend by memory contexts for plperl and pltcl |
| Previous Message | Amit Langote | 2016-08-31 07:35:41 | Re: Declarative partitioning - another take |