Re: JDBC, prepared queries, and partitioning - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: JDBC, prepared queries, and partitioning
Date
Msg-id Pine.BSO.4.64.0802131602540.9961@leary.csoft.net
Whole thread Raw
In response to Re: JDBC, prepared queries, and partitioning  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: JDBC, prepared queries, and partitioning  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-jdbc

On Wed, 13 Feb 2008, Simon Riggs wrote:

> On Wed, 2008-02-13 at 15:43 -0500, Kris Jurka wrote:
>
>> No, in V3 all prepared statements are prepared regardless of the
>> threshold.
>
> Am I reading the wrong documentation?
> http://jdbc.postgresql.org/documentation/83/connect.html#connection-parameters
>

The documentation is just simplifying the complexities of named vs unnamed
statements.  Aside from a couple of exceptions, an unnamed prepared
statement should perform equivalently to direct execution of the literal
query.  Describing it as semi-prepared is complicated and not particularly
useful if there is no way to get non-prepared behavior.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Simon Riggs
Date:
Subject: Re: JDBC, prepared queries, and partitioning
Next
From: Simon Riggs
Date:
Subject: Re: JDBC, prepared queries, and partitioning