Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Dang Minh Huong <kakalot49(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Date: 2016-02-08 23:06:41
Message-ID: 56B91F81.7000703@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Dang,

On 2016/02/08 22:54, Dang Minh Huong wrote:
> Hi,
>
>> I have tested some version of psqlODBC between 09.00.0310 ~ 09.03.0400,
>> and found that exactly version 09.03.0100 made the degradation of
>> performance
>> in executing my batch (it is not related to replication, i found that).
>>
>> I will try to find out which commit did it and how to avoid this issues.
>>
>
> I have confirmed commits in version 09.03.0100 and found that,
> the below commit exactly caused the degration of perfomance.
>
> http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commitdiff;h=9fd39495580ada6ff7d989d19fa9f83ed3b2c82e
>
> MSDTC is not related to my application (i'm using unixODBC). So, the
> other
> changes in above commit made performance down, but i am not clearly what
> they are.
> Could you confirm for me the above commit.
>

Hmm, it's strange.
Anyway I would examine the commit.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Venkatesan, Sekhar 2016-02-09 04:10:05 Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
Previous Message Dang Minh Huong 2016-02-08 13:54:56 Re: Degradation of performance when upgrade psqlodbc to 09.03.0400