Re: postgres_fdw aggregate pushdown for group by with expressions

Поиск
Список
Период
Сортировка
Искать
От
Michał Kłeczek
Тема
Re: postgres_fdw aggregate pushdown for group by with expressions
Дата
Msg-id
1BFADE7F-647F-4BCA-8AA4-9E8CC2260898@kleczek.org
Ответ на
Список
Дерево обсуждения
postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek <michal@kleczek.org>
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek <michal@kleczek.org>
Re: postgres_fdw aggregate pushdown for group by with expressions Adrian Klaver <adrian.klaver@aklaver.com>
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek <michal@kleczek.org>
Re: postgres_fdw aggregate pushdown for group by with expressions Tom Lane <tgl@sss.pgh.pa.us>
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek <michal@kleczek.org>
Re: postgres_fdw aggregate pushdown for group by with expressions Tom Lane <tgl@sss.pgh.pa.us>
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek <michal@kleczek.org>
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek <michal@kleczek.org>
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek <michal@kleczek.org>
Thanks for help.

I’ve performed some more tests and it seems expressions with “extract” function are not pushed down at all -
the WHERE criteria from the following query are not pushed down as well and filter is performed locally:
SELECT
  *
FROM
  t1
WHERE extract(YEAR FROM date_column) = 2023
I was under impression that “extract” meets all criteria for pushable expressions - looks like I am wrong?
What would be the expression to achieve the same but such that postgres_fdw would push it down?

What Postgres versions on both ends?

16.1 on both sides


What does

select proname, prosrc,  provolatile from pg_proc where proname = 'extract';

return?

extract | extract_date | i

(and bunch of similar records for other types - for timestampz provolatile is “s”)

Michal
В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
От: Tom Lane
Дата:
FAQ