Call one function in other fucntion postgres take a lot of time

Highlighted
Level 3 Traveller

Call one function in other fucntion postgres take a lot of time

 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

2 REPLIES 2
Highlighted
Level 3 Traveller

Re: Call one function in other fucntion postgres take a lot of time

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.

 

 

 

 

 

Highlighted
Level 3 Adventurer

Re: Call one function in other fucntion postgres take a lot of time

Hi GSTDBTEAM,

 

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.

 

Thanks,
Swagata

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks