Re: Degradation of performance when upgrade psqlodbc to 09.03.0400 - Mailing list pgsql-odbc

From Dang Minh Huong
Subject Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Date
Msg-id A38ECDFE-0499-4859-A0DD-832050A9B6F1@gmail.com
Whole thread Raw
In response to Re: Degradation of performance when upgrade psqlodbc to 09.03.0400  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Responses Re: Degradation of performance when upgrade psqlodbc to 09.03.0400  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc
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@dream.email.ne.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.


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

pgsql-odbc by date:

Previous
From: "Venkatesan, Sekhar"
Date:
Subject: Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
Next
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!