Re: Special-case executor expression steps for common combinations

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Special-case executor expression steps for common combinations
Дата
Msg-id CAApHDvppskp5khOk5Zbvc=-C5WPLyA_xhnkLufuc-Xdd8CjQaw@mail.gmail.com
обсуждение исходный текст
Ответ на Special-case executor expression steps for common combinations  (Daniel Gustafsson <daniel@yesql.se>)
Список pgsql-hackers
Дерево обсуждения 
On Thu, 12 Oct 2023 at 22:54, Daniel Gustafsson <daniel@yesql.se> wrote:
> EEOP_FUNCEXPR_STRICT_* (10M iterations):
>     master  : (7503.317, 7553.691, 7634.524)
>     patched : (7422.756, 7455.120, 7492.393)
>
> pgbench:
>     master  : (3653.83, 3792.97, 3863.70)
>     patched : (3743.04, 3830.02, 3869.80)
>
> Thoughts?

Did any of these tests compile the expression with JIT?

If not, how does the performance compare for a query that JITs the expression?

David

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

Предыдущее
От: "Hayato Kuroda (Fujitsu)"
Дата:
Сообщение: RE: [PoC] pg_upgrade: allow to upgrade publisher node
Следующее
От: David Rowley
Дата:
Сообщение: Re: Problem, partition pruning for prepared statement with IS NULL clause.