Hello people need some suggestions in postgres fucntion.
As developed 3 funtions based on requriment and now iam calling the 3 functions in another function called function 4.
When iam running the 4th function that containing the other 3 function calling in it, is takeing 20 min of thime to complte the program for 200000 of records.
Where as all the 4 program runned individually it take 5 min to all the function.
Hope you are doing good.
If possible, could you please share the procedure codes and also sample data. So that we can reproduce the scenario at our end.
Also please share the output of show all; from your database.