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