Re: UseServerSidePrepare default

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: UseServerSidePrepare default
Date: 2013-08-22 10:57:08
Message-ID: CADK3HHKCcALxzYXmuKiRcmje7MGZ=ff-RStinkTH2auw8-7bMA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Heikki,

I presume this is similar to JDBC's use of server side prepare. If so do
you see a performance problem with servers older than 9.2 since Tom's fix
to planning prepared statements is only in 9.2 and above ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Thu, Aug 22, 2013 at 3:06 AM, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com
> wrote:

> On 19.04.2013 22:14, Heikki Linnakangas wrote:
>
>> The docs on ODBC configuration options recommend UseServerSidePrepare=1
>> for server versions 7.4 and above. That's a good recommendation. Given
>> that "7.4 and above" covers all supported versions of PostreSQL, and
>> every reasonable version people might want to use a new driver with, how
>> about we make UseServerSidePrepare=1 the default, so that people don't
>> need to set it manually?
>>
>
> I hear no objections, so committed. UseServerSidePrepare=1 is now the
> default, for the upcoming driver version 9.3.X.
>
> - Heikki
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-odbc<http://www.postgresql.org/mailpref/pgsql-odbc>
>

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Heikki Linnakangas 2013-08-22 11:15:04 Re: UseServerSidePrepare default
Previous Message Heikki Linnakangas 2013-08-22 07:06:05 Re: UseServerSidePrepare default