Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
To: pgsql-performance@lists.postgresql.org
References: 
 <MN2PR15MB2560D77DFB58BD893E2EAAAD85C29@MN2PR15MB2560.namprd15.prod.outlook.com>
 <MN2PR15MB2560AE2A878FBBE88DCFF33385C29@MN2PR15MB2560.namprd15.prod.outlook.com>
 <2092859.1629558281@sss.pgh.pa.us>
From: Mladen Gogala <gogala.mladen@gmail.com>
Message-ID: <01186dcc-bf1e-0c25-b6e6-9a1c6b52d226@gmail.com>
Date: Sat, 21 Aug 2021 11:29:44 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.11.0
MIME-Version: 1.0
In-Reply-To: <2092859.1629558281@sss.pgh.pa.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/01186dcc-bf1e-0c25-b6e6-9a1c6b52d226%40gmail.com>
Precedence: bulk

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