RE: Partial aggregates pushdown

Поиск
Список
Период
Сортировка
Искать
От
Fujii.Yuki@df.MitsubishiElectric.co.jp
Тема
RE: Partial aggregates pushdown
Дата
Msg-id
TY2PR01MB3835F15566AA6E8D25E3516195CB2@TY2PR01MB3835.jpnprd01.prod.outlook.com
Ответ на
Список
Дерево обсуждения
Partial aggregates pushdown Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: Partial aggregates pushdown Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Partial aggregates pushdown Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: Partial aggregates pushdown Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Partial aggregates pushdown Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: Partial aggregates pushdown Ilya Gladyshev <i.gladyshev@postgrespro.ru>
Re: Partial aggregates pushdown Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: Partial aggregates pushdown Daniel Gustafsson <daniel@yesql.se>
Re: Partial aggregates pushdown Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: Partial aggregates pushdown Daniel Gustafsson <daniel@yesql.se>
Re: Partial aggregates pushdown Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: Partial aggregates pushdown Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Partial aggregates pushdown Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: Partial aggregates pushdown Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: Partial aggregates pushdown Ilya Gladyshev <i.gladyshev@postgrespro.ru>
Re: Partial aggregates pushdown Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Partial aggregates pushdown Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: Partial aggregates pushdown Tomas Vondra <tomas.vondra@enterprisedb.com>
Hi Alexander, hackers.

> From: Alexander Pyhalov 
> Sent: Tuesday, May 28, 2024 2:45 PM
> The fix was to set child_agg->agg_partial to orig_agg->agg_partial in
> convert_combining_aggrefs(), it's already in the patch, as well as the example -
> without this fix
I've just realized that you've added the necessary tests. I forgot to respond, my apologies.

> From: Alexander Pyhalov 
> Sent: Tuesday, May 28, 2024 2:58 PM
> BTW, there's I have an issue with test results in the last version of the patch.
> Attaching regression diffs.
> I have partial sum over c_interval instead of sum(c_interval).
I think the difference stems from the commit[1], which add serialization function
to sum(interval). I will fix it.

Best regards, Yuki Fujii
--
Yuki Fujii
Information Technology R&D Center, Mitsubishi Electric Corporation

[1] https://github.com/postgres/postgres/commit/519fc1bd9e9d7b408903e44f55f83f6db30742b7




В списке pgsql-hackers по дате отправления
От: Fujii.Yuki@df.MitsubishiElectric.co.jp
Дата:
От: Yugo NAGATA
Дата:
FAQ