Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

Hi Inoue-san,

Hi Dang,

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

odbc.ini does not contain SOCKET option.

I will check the app whether contain it in connection string or not.

And reply you soon.

Thanks and best regards.

bocap

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@dream.email.ne.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