Re: Function call very slow from JDBC/java but super fast from DBear

2023-08-09 Thread David G. Johnston
On Tuesday, August 8, 2023, An, Hongguo (CORP) wrote: > Hi: > > I have a function, if I call it from DBeaver, it returns within a minute. > > *call* commonhp.run_unified_profile_load_script_work_assignment_details( > 'BACDHP', 'G3XPM6YE2JHMSQA2'); > > but if I called it from spring jdbc template,

Re: Function call very slow from JDBC/java but super fast from DBear

2023-08-09 Thread An, Hongguo (CORP)
Cramer Date: Wednesday, August 9, 2023 at 6:30 AM To: An, Hongguo (CORP) Cc: pgsql-performance@lists.postgresql.org Subject: Re: Function call very slow from JDBC/java but super fast from DBear WARNING: Do not click links or open attachments unless you recognize the source of the email and know

Re: Function call very slow from JDBC/java but super fast from DBear

2023-08-09 Thread Dave Cramer
On Tue, 8 Aug 2023 at 17:07, An, Hongguo (CORP) wrote: > Hi: > > I have a function, if I call it from DBeaver, it returns within a minute. > > > > *call* commonhp.run_unified_profile_load_script_work_assignment_details( > 'BACDHP', 'G3XPM6YE2JHMSQA2'); > > > > > > but if I called it from spring j

Function call very slow from JDBC/java but super fast from DBear

2023-08-08 Thread An, Hongguo (CORP)
Hi: I have a function, if I call it from DBeaver, it returns within a minute. call commonhp.run_unified_profile_load_script_work_assignment_details('BACDHP', 'G3XPM6YE2JHMSQA2'); but if I called it from spring jdbc template, it never comes back: public void runTransform(String proc, Init