Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

Hi Dang,

Doesn't your odbc.ini or connection string contain SOCKET option?

regards,
Hiroshi Inoue

On 2016/02/11 8:44, Dang Minh Huong wrote:
> 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 <mailto: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