Re: [GENERAL] 7.3 Prepared statements [Viruschecked]

From: "Patric Bechtel" <bechtel(at)ipcon(dot)de>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Charles H(dot) Woloszynski" <chw(at)clearmetrix(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [GENERAL] 7.3 Prepared statements [Viruschecked]
Date: 2003-01-03 14:21:36
Message-ID: 20030103142155.A1432474E61@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On Fri, 03 Jan 2003 08:19:38 -0500, Charles H. Woloszynski wrote:

Please see my answer on the list... it was especially addressed to you!

Patric

>I saw this on the GENERAL list and this 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
>
>
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Dalitz 2003-01-03 14:48:23 rules in other RDBS?
Previous Message Oliver Elphick 2003-01-03 13:29:22 Re: French date

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-01-03 14:30:18 Re: Patch for streaming resultsets
Previous Message Charles H. Woloszynski 2003-01-03 13:19:38 Re: [GENERAL] 7.3 Prepared statements