Re: Performance degradation with non-null proconfig

2020-11-19 Thread Simon Riggs
On Thu, 19 Nov 2020 at 09:10, Alastair McKinley wrote: > > Hi all, > > I recently came across a subtle performance issue when working with some > compiled UDFs to optimise a workload. > > These UDFs accidently had "set search_path = 'public'" in their definition. > When profiling with perf, I n

Performance degradation with non-null proconfig

2020-11-19 Thread Alastair McKinley
Hi all, I recently came across a subtle performance issue when working with some compiled UDFs to optimise a workload. These UDFs accidently had "set search_path = 'public'" in their definition. When profiling with perf, I noticed a large amount of elapsed time spent in the function void