| From: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Catching up with performance & PostgreSQL 15 |
| Date: | 2022-11-29 14:17:48 |
| Message-ID: | 401ac59b-067f-28f2-547d-417ee5c49c39@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 11/29/22 03:36, Alvaro Herrera wrote:
> On 2022-Nov-28, Mladen Gogala wrote:
>
>> As for JIT, I've recently asked that question myself. I was told that
>> PostgreSQL with LLVM enabled performs approximately 25% better than without
>> it.
> Hmm, actually, normally you're better off turning JIT off, because it's
> very common to diagnose cases of queries that become much, much slower
> because of it. Some queries do become faster, but it's not a wide
> margin, and it's not a lot. There are rare cases where JIT is
> beneficial, but those tend to be queries that take upwards of several
> seconds already.
>
> IMO it was a mistake to turn JIT on in the default config, so that's one
> thing you'll likely want to change.
>
Hmmm, I think I will run pgbench with and without JIT on and see the
difference.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-11-29 14:31:36 | Re: Catching up with performance & PostgreSQL 15 |
| Previous Message | Mladen Gogala | 2022-11-29 14:16:11 | Re: Catching up with performance & PostgreSQL 15 |