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: bharadwaj@sailotech.in
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.......
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:noreply@postgresql.org]
Sent: Tuesday, February 13, 2018 11:45 AM
To: pgsql-bugs@lists.postgresql.org
Cc: bharadwaj@sailotech.in
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: bharadwaj@sailotech.in
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.......