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

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