Hi,
>
>
> Yeah. well, hm. Is the function returning a whole bunch of data?
> Also, try confirming the slow runtime from the server's point of view;
> log_min_duration_statement is a good setting for that.
>
I did try those options. In the end, removing an order by (it was not
necessary) from
On Tue, Aug 28, 2012 at 2:11 AM, Pavan Deolasee
wrote:
>
>
> On Mon, Aug 27, 2012 at 6:07 PM, Jayadevan M
> wrote:
>>
>> Hello all,
>>
>> 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 state
On Mon, Aug 27, 2012 at 6:07 PM, Jayadevan M
wrote:
> Hello all,
>
> 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
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
f
Hello all,
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
filter
