Postgres Pro
Downloads
Home   >   mailing lists

Re: Degradation of performance when upgrade psqlodbc to 09.03.0400 - Mailing list pgsql-odbc

From Dang Minh Huong
Subject Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Date
Msg-id 1EDD2A39-78FA-4C80-AC35-9C9FF658C94F@gmail.com
Whole thread Raw
In response to Re: Degradation of performance when upgrade psqlodbc to 09.03.0400  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Responses Re: Degradation of performance when upgrade psqlodbc to 09.03.0400  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc
Tree view
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


pgsql-odbc by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PSQL iODBC driver on mac os x 10.10.3 (Yosemite)
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: Degradation of performance when upgrade psqlodbc to 09.03.0400