Обсуждение: BUG #15062: Calling 3 function in one other function

Поиск
Список
Период
Сортировка

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:      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.......


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

От
Greg Clough
Дата:
Hi Bharath,

This isn't a bug, and isn't particularly well documented.  Can I suggest that you document the problem, provide a
simpletest-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.......