Re: Aggregate Push Down - Performing aggregation on foreign server

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Aggregate Push Down - Performing aggregation on foreign server
Дата
Msg-id CAFj8pRB6+y6R3unWOiucuiy3b10qTEYzihirCUhqU87R-ozTDA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Aggregate Push Down - Performing aggregation on foreign server  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Aggregate Push Down - Performing aggregation on foreign server  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список pgsql-hackers
Дерево обсуждения


2016-08-31 9:00 GMT+02:00 Robert Haas <robertmhaas@gmail.com>:
On Wed, Aug 31, 2016 at 11:56 AM, Pavel Stehule <pavel.stehule@gmail.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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Declarative partitioning - another take
Следующее
От: Michael Paquier
Дата:
Сообщение: Replace use malloc() & friend by memory contexts for plperl and pltcl