Re: Query performance in 9.6.24 vs 14.10 - Mailing list pgsql-general

From Bob Jolliffe
Subject Re: Query performance in 9.6.24 vs 14.10
Date
Msg-id CACd=f9fLxuOgtfb0RRi08Qn5edPOFUBK_E5q-DyC4gBqU7KbMg@mail.gmail.com
Whole thread Raw
In response to Re: Query performance in 9.6.24 vs 14.10  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general
Thanks for the update. 

On Mon, Jan 29, 2024, 16:53 Ron Johnson <ronljohnsonjr@gmail.com> wrote:
According to my tests, sometimes JIT is a little faster, and sometimes it's a little slower. Mostly within the realm of statistical noise (especially with each query having a sample size of only 13, on a VM that lives on a probably-busy host).

On Mon, Jan 29, 2024 at 9:18 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
Yes, jit=on.

I'll test them with jit=off, to see the difference.  (The application is 3rd party, so will change it at the system level.)

On Mon, Jan 29, 2024 at 7:09 AM Bob Jolliffe <bobjolliffe@gmail.com> wrote:
Out of curiosity, is the pg14 running with the default jit=on setting?  

This is obviously entirely due to the nature of the particular queries themselves, but we found that for our workloads that pg versions greater than 11 were exacting a huge cost due to the jit compiler.  Once we explicitly turned jit=off we started to see improvements. 

pgsql-general by date:

Previous
From: Shaheed Haque
Date:
Subject: Re: Scriptable way to validate a pg_dump restore ?
Next
From: Adrian Klaver
Date:
Subject: Re: Scriptable way to validate a pg_dump restore ?