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
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