Finding every use of a built-in function

[Kurlaev Jaroslav]

Hi hackers,

I'm not sure if it's the best list for my question but I have a following 
problem.

I have an existing DB with lots of data and I need to modify the behavior of 
one specific
built-in function. I can of course create my own function and redefine the 
behavior but
now I need to find every single instance of the old function being used. There 
is
dependency tracking with pg_depend but it doesn't work for built-in functions.

I also tried a different approach and tried to create a C-language hook for 
function
call but hooks also don't work for built-in functions.

Do you have some advice for me?

Thanks.

RE: Finding every use of a built-in function

[Kurlaev Jaroslav]

> plpgsq_check can show dependencies 
> https://github.com/okbob/plpgsql_check#dependency-list

That's not exactly what I was looking for, but it's a useful tool that could 
help me anyway. Thanks!

RE: Smoothing the subtrans performance catastrophe

[Kurlaev Jaroslav]

Hello Simon,

Can you please provide the test cases that you used to plot the performance
graph you've attached.
Also do you know if your optimization will be useful for a very large amount
of subtransactions per transaction (around 1000)?

-- 
Thanks,
Yaroslav