Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

From: Dang Minh Huong <kakalot49(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Date: 2016-02-15 09:12:55
Message-ID: 41778DE9-954C-4663-876B-4FCC535882B9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Inoue-san, Heikki-san,

Sorry for continuous disturbing you in this topic.

We found the below SQLSetConnectAttr issue, which was solved in 09.05.
Follow the topic and we solved performance problem in 09.03.0340 by do SQLSetConnectAttr after create connection.

http://postgresql.nabble.com/issue-SQLDriverConnect-will-clear-existing-connect-attribute-setting-td5832902.html#a5836129

As my confirmation, SQLSetConnectAttr issue is started from 09.03.0100. Which your "Revise MSDTC support" patch is applied.
Does your patch is related to SQLSetConnectAttr issue above?
If yes, how it does ?
# Sorry but i just want to know the root cause.

Thanks and best regards,
bocap

>
>
>> On 13 February 2016 15:54:53 EET, Dang Minh Huong <kakalot49(at)gmail(dot)com> wrote:
>> 9.5.0100 is required libpq version greater than 9.1 to build.
>> I am not yet tried but do it work fine with PostgreSQL 9.1?
>
> Yeah, should work fine.
>
> - Heikki

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2016-02-15 11:53:05 Re: PostgreSQL: Inserting NULL values adds empty string.
Previous Message Venkatesan, Sekhar 2016-02-15 09:07:19 Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!