Re: Special-case executor expression steps for common combinations

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Special-case executor expression steps for common combinations
Date: 2023-10-12 12:04:21
Message-ID: CAApHDvppskp5khOk5Zbvc=-C5WPLyA_xhnkLufuc-Xdd8CjQaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 12 Oct 2023 at 22:54, Daniel Gustafsson <daniel(at)yesql(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2023-10-12 12:27:57 Re: Problem, partition pruning for prepared statement with IS NULL clause.
Previous Message Hayato Kuroda (Fujitsu) 2023-10-12 11:42:10 RE: [PoC] pg_upgrade: allow to upgrade publisher node