From: Mladen Gogala <gogala.mladen@gmail.com>
To: pgsql-performance@lists.postgresql.org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date: Sat, 21 Aug 2021 11:29:44 -0400
Message-ID: <01186dcc-bf1e-0c25-b6e6-9a1c6b52d226@gmail.com> (raw)
In-Reply-To: <2092859.1629558281@sss.pgh.pa.us>
References: <MN2PR15MB2560D77DFB58BD893E2EAAAD85C29@MN2PR15MB2560.namprd15.prod.outlook.com>
<MN2PR15MB2560AE2A878FBBE88DCFF33385C29@MN2PR15MB2560.namprd15.prod.outlook.com>
<2092859.1629558281@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gogala.mladen@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
In-Reply-To: <01186dcc-bf1e-0c25-b6e6-9a1c6b52d226@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox