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

From: Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, ldh(at)laurent-hasson(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Date: 2021-08-21 20:58:21
Message-ID: CAOtHd0Cprz7tnb2oKr=C=TQWcD0XC8qqST7NKH91pzwWjoQBkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I happen to have a stock 13.3 and 11.12 on Ubuntu here so I thought I'd
contribute numbers in case it's helpful:

v13.3:
Time: 4368.413 ms (00:04.368)
Time: 837.046 ms

v11.12:
Time: 5178.595 ms (00:05.179)
Time: 1027.857 ms (00:01.028)

So I'm also seeing a slight improvement in 13, not a degradation.
auto_explain and pg_stat_statements are installed in both; otherwise
they're pretty vanilla.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2021-08-21 21:24:11 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Previous Message Justin Pryzby 2021-08-21 19:19:50 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4