Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date: 2021-08-21 15:29:44
Message-ID: 01186dcc-bf1e-0c25-b6e6-9a1c6b52d226@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I know that 14 is a beta version but the performance is significantly
worse than v13 (I assume it's 13.4). Head revision is better than v14
but still worse than v13.  Can you expand a bit on the difference? Where
does the difference come from? Are there any differences in the
execution plan?  I am looking at the first query, taking slightly more
than 12s.

Regards

On 8/21/21 11:04 AM, Tom Lane wrote:
> HEAD:
> Time: 12234.297 ms (00:12.234)
> Time: 3029.643 ms (00:03.030)
>
> v14:
> Time: 12519.038 ms (00:12.519)
> Time: 3211.315 ms (00:03.211)
>
> v13:
> Time: 12132.026 ms (00:12.132)
> Time: 3114.582 ms (00:03.115)

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ldh@laurent-hasson.com 2021-08-21 16:01:16 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Previous Message Tom Lane 2021-08-21 15:04:41 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4