Re: [GENERAL] 7.3 Prepared statements [Viruschecked]

On Thu, 2 Jan 2003 23:47:05 -0500 (EST), Bruce Momjian wrote:

>
>I would ask on the jdbc lists.  I am Cc'ing them, and removing the
>general list.
>
>---------------------------------------------------------------------------
>
>Charles H. Woloszynski wrote:
>> Bruce:
>> 
>> Do you mean that, under JDBC with PG7.3, it will use the stored 
>> execution plan, or that we should ask the JDBC driver maintainers to 
>> work to use this feature to use the stored executiong plan?
>> 
>> I am obviously interested in helping make this happen to improve the 
>> overall PostgreSQL solution.  Should I contact someone specific about 
>> this to see if there are plans to make this happen in the near future? 
>>  I think I have a solid framework to test its effectiveness with decent 
>> performance monitoring tools already in place.
>> 
>> Thanks,
>> 
>> Charlie


As I dipped my nose a bit deeper into that the last few days, I think
I can tell you that the JDBC driver (7.3.1 and the current CVS)
doesn't use server side prepared statements automatically.
I changed that with a patch I announced yesterday. As soon as it will
be accepted, it will.
If you want to try it out *NOW*, you should to something like this:
((org.postgresql.jdbc1.AbstractJdbc1Statement)statement).setUseServerPrepare(true);
It's kind of clumsy, and does clue your app to pgsql a bit, but for
a test, it's ok. 
(You could also try out my patch, it's on the pgsql-patches list :-))
Don't overestimate the performance win for prepared statements, as the
optimizer can NOT really calculated the perfect plan, if the statement
is too unspecific.
At the moment there's a bug regarding boolean values in server side
prepared statements. My patch fixes this, too. I hope it will be
applied soon...

tia

Patric