Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

Hi Inoue-san,

Thanks for response.
And so sorry for disturbing you at this time.
Please ask if you need aditional information.

I also analyzed PostgreSQL's log. Generally it became slower
(number of executed SQL statements in a period of time are degraded)
when using 09.03.0100~.

And, it sounds that number of CPUs is related to the degration difference.
In 2 environments i have tested,
First one with 8 cores (64GB memory) and the degration as i showed
in previous mail. In the other with 10 cores (64GB memory), the degration
difference become lesser.

Thanks and best regards.
bocap

> On Feb 9, 28 Heisei, at 08:06, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>
> 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>http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commitdiff;h=9fd39495580ada6ff7d989d19fa9f83ed3b2c82e <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