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

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