Postgres Pro
Downloads
Home   >   mailing lists

Re: Special-case executor expression steps for common combinations - Mailing list pgsql-hackers

From David Rowley
Subject Re: Special-case executor expression steps for common combinations
Date
Msg-id CAApHDvppskp5khOk5Zbvc=-C5WPLyA_xhnkLufuc-Xdd8CjQaw@mail.gmail.com
Whole thread Raw
In response to Special-case executor expression steps for common combinations  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: [PoC] pg_upgrade: allow to upgrade publisher node
Next
From: David Rowley
Date:
Subject: Re: Problem, partition pruning for prepared statement with IS NULL clause.