Jayadevan M wrote: > I have a plpgsql function that takes a few seconds (less than 5) when executed from psql. The same > function, when invoked from java via a prepared statement takes a few minutes. There are a few queries > in the function. Out of these, the first query takes input parameters for filtering the data. It is > this query which takes a long time when the procedure is invoked from java. To ensure that the query > does use actual values (and not bind variables) for optimization, we used > > execute > ' > select x.col_type_desc,x.acc_id,acc_svr from (..... > ' > using d_from_date,d_to_date > > It did not help. Any suggestions? It is from_date and to_date on which data gets filtered. We are > using the same values for filtering, when we execute it from java/psql Use the auto_explain contrib with auto_explain.log_nested_statements=on to see the statements that are really executed and compare! Yours, Laurenz Albe -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
