BUG #15062: Calling 3 function in one other function

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15062: Calling 3 function in one other function

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15062
Logged by:          bharath sagaram
Email address:      [hidden email]
PostgreSQL version: 10.1
Operating system:   Windows 10
Description:        

Hi Team,
I developed 3 function and calling in  function 4. It taken then 20 min of
time.
Where as am calling the all the function individually it take 5 min of
time.

Tested with 200000 of records.  

Help I want to reduce the time of the process.......

Reply | Threaded
Open this post in threaded view
|

RE: BUG #15062: Calling 3 function in one other function

Greg Clough-5
Hi Bharath,

This isn't a bug, and isn't particularly well documented.  Can I suggest that you document the problem, provide a simple test-case, and then post it to a more relevant list, such as pgsql-performance:

https://www.postgresql.org/list/pgsql-performance/

Greg Clough
Senior Technology Engineer

Ipreo
Castle House | 37-35 Paul St | London EC2A 4LS

-----Original Message-----
From: PG Bug reporting form [mailto:[hidden email]]
Sent: Tuesday, February 13, 2018 11:45 AM
To: [hidden email]
Cc: [hidden email]
Subject: BUG #15062: Calling 3 function in one other function

The following bug has been logged on the website:

Bug reference:      15062
Logged by:          bharath sagaram
Email address:      [hidden email]
PostgreSQL version: 10.1
Operating system:   Windows 10
Description:        

Hi Team,
I developed 3 function and calling in  function 4. It taken then 20 min of time.
Where as am calling the all the function individually it take 5 min of time.

Tested with 200000 of records.  

Help I want to reduce the time of the process.......

Previous Thread Next Thread