postgres_fdw aggregate pushdown for group by with expressions

Поиск
Список
Период
Сортировка
От Michał Kłeczek
Тема postgres_fdw aggregate pushdown for group by with expressions
Дата
Msg-id AF30BDFB-7215-4E8C-BF11-C97573199D6C@kleczek.org
обсуждение исходный текст
Ответы Re: postgres_fdw aggregate pushdown for group by with expressions
Re: postgres_fdw aggregate pushdown for group by with expressions
Список pgsql-general
Hi,

I have the following foreign table:

CREATE FOREIGN TABLE t1 (
  grouping_column text,
  date_column date,
  whatever_data int
);

The query is:

SELECT
  sum(whatever_data)
FROM
  t1
GROUP BY
  grouping_colulmn, extract(YEAR FROM date_column), extract(MONTH FROM date_column);

From my (preliminary) testing postgres_fdw will not push down this aggregate query
- it will happily push down query with only “grouping_column” or “grouping_column, date_column" in GROUP BY

Is there a way to somehow push down the query with expressions in GROUP BY?

Thanks,
Michal


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

Предыдущее
От: Guyren Howe
Дата:
Сообщение: Thoughts on user-defined types for talk at Postgres conference?
Следующее
От: Michał Kłeczek
Дата:
Сообщение: Re: postgres_fdw aggregate pushdown for group by with expressions