Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

Поиск
Список
Период
Сортировка
От Dang Minh Huong
Тема Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Дата
Msg-id A38ECDFE-0499-4859-A0DD-832050A9B6F1@gmail.com
обсуждение исходный текст
Ответ на Re: Degradation of performance when upgrade psqlodbc to 09.03.0400  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Ответы Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Список 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 по дате отправления: