Re: [GENERAL] 7.3 Prepared statements

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
>
>
>
>
> 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
>
>
>
>
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073