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

Ranier Vilela <ranier.vf@gmail.com>

From: Ranier Vilela <ranier.vf@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>, ldh@laurent-hasson.com, pgsql-performance@postgresql.org
Date: 2021-08-22T23:16:31Z
Lists: pgsql-performance
Em dom., 22 de ago. de 2021 às 14:50, Tom Lane <tgl@sss.pgh.pa.us> escreveu:

> Justin Pryzby <pryzby@telsasoft.com> writes:
> > This looks useful, thanks.  It seems like maybe win64 builds are very
> slow
> > running this:
>
> > exec_stmt_block() /
> > BeginInternalSubTransaction() /
> > AbortSubTransaction() /
> > reschedule_timeouts() /
> > schedule_alarm() /
> > setitimer() /
> > pg_timer_thread() /
> > WaitForSingleObjectEx ()
>
> Hmm ... we should not be there unless there are active timeout events,
> which there aren't by default.  I wonder whether either Ranier or
> Laurent have statement_timeout or some similar option enabled.
>
Tom, none settings, all default from Postgres install.

regards,
Ranier Vilela