Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

Hi Inoue-san,

Sorry for my lately response.
I am not remember exactly now, but they are like below.
# only connection related parameters

odbc.ini

[PostgreSQL]
Driver = PostgreSQLDriver
Database = testdb
Servername = localhost
UserName = postgres
Password = postgres
Port = 5432

odbcinst.ini

[PostgreSQLDriver]
Description = PostgreSQL Driver
Driver = [path to libodbcpsqlw.so file]

Thanks and best regards,
bocap

> On Feb 10, 28 Heisei, at 22:24, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>
> Hi Dang,
>
> Thanks.
>
> How are you setting your ODBC.INI(and ODBCINST.INI)?
>
> regards,
> Hiroshi Inoue
>
> On 2016/02/10 12:20, Dang Minh Huong wrote:
>> Hi Inoue-san,
>>
>>
>>> Hi Dang,
>>>
>>> On 2016/02/09 20:13, Dang Minh Huong wrote:
>>>> Hi Inoue-san,
>>>>
>>>> Thanks for response.
>>>> And so sorry for disturbing you at this time.
>>>> Please ask if you need aditional information.
>>>>
>>>
>>> Are your applications multi-threaded or multi-process?
>>> How many connections do your applications use?
>>>
>>
>> It is about 5 connections. And one of them do almost task.
>> DB lock wait also not occured as my confirm.
>>
>> Multi-thread is used but we do not using multi-thread in the same connection.
>> # multi-process is not used in the app.
>>
>> Thanks and best regards,
>> bocap
>>
>>> regards,
>>> Hiroshi Inoue
>