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