Re: 7.3 Prepared statements

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

Bruce Momjian wrote:

>Sorry, I don't know if it does that yet, but I am sure it will if it
>doesn't already.
>
>---------------------------------------------------------------------------
>
>Charles H. Woloszynski wrote:
>
>
>>I realize that this is a bit off topic, but your answer got me thinking.
>> Do JDBC Prepared statements get the same saved execution plan support?
>> We currently use PreparedStatements in our framework for JDBC access.
>> We currently do not retain the PreparedStatement between uses, but if
>>PostreSQL caches the execution plan, we may need to change our design.
>>
>>Thanks,
>>
>>Charlie
>>
>>
>>Bruce Momjian wrote:
>>
>>
>>
>>>A view is just syntaxic sugar added to a query that references the view.
>>>A preparted statement actually saves the execution plan for repeated
>>>execution.
>>>
>>>---------------------------------------------------------------------------
>>>
>>>Francisco J Reyes wrote:
>>>
>>>
>>>
>>>
>>>>On 17 Dec 2002, Neil Conway wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>On Tue, 2002-12-17 at 10:19, Ericson Smith wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>1. What is the lifetime of the plan created?
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>From the PREPARE reference page:
>>>>>
>>>>>Prepared queries are stored locally (in the current backend), and only
>>>>>exist for the duration of the current database session.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>What is the difference/advantage between a prepared query and a view?
>>>>
>>>>
>>>>---------------------------(end of broadcast)---------------------------
>>>>TIP 4: Don't 'kill -9' the postmaster
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>--
>>
>>
>>Charles H. Woloszynski
>>
>>ClearMetrix, Inc.
>>115 Research Drive
>>Bethlehem, PA 18015
>>
>>tel: 610-419-2210 x400
>>fax: 240-371-3256
>>web: www.clearmetrix.com
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>

--

Charles H. Woloszynski

ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015

tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com