Re: [PERFORM] JDBC/Stored procedure performance issue

2008-01-31 Thread Claire McLister
, which, however, is more acceptable than 3000ms. Will upgrade to 8.1 at some point, but would like to get reasonable performance with 7.4 until then. I did increase the statistics target to 1000. Claire On Jan 28, 2008, at 12:51 PM, Tom Lane wrote: Claire McLister [EMAIL PROTECTED] writes

[PERFORM] JDBC/Stored procedure performance issue

2008-01-28 Thread Claire McLister
; ' LANGUAGE plpgsql STABLE RETURNS NULL ON NULL INPUT; Can someone please tell me what we are doing wrong? Any help would be greatly appreciated. Thanks Claire -- Claire McLister[EMAIL PROTECTED] 21060 Homestead Road Suite 150 Cupertino, CA 95014408-733-2737