Re: [INTERFACES] PostgreSQL, and ODBC statement handles - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] PostgreSQL, and ODBC statement handles
Date
Msg-id 18800.1493871169@sss.pgh.pa.us
Whole thread Raw
In response to [INTERFACES] PostgreSQL, and ODBC statement handles  (Reza Taheri <rtaheri@vmware.com>)
List pgsql-interfaces
Reza Taheri <rtaheri@vmware.com> writes:
> I am running a benchmark (TPCx-V) with a single process on the client
> system handing all the load. Each connection to the server is in a
> separate thread with its own connection to PGSQL, and its own connection
> handle and statement handle.  I am facing a contention problem with ODBC
> on the client side. strace and perf top show we are serializing over
> what appears to be accesses to the ODBC statement handle. Contention
> goes away if I use multiple processes instead of multiple threads within
> a process.

No idea about the answer to this, but I suggest that you might find
help on the pgsql-odbc list, if no one answers here.
        regards, tom lane



pgsql-interfaces by date:

Previous
From: Reza Taheri
Date:
Subject: [INTERFACES] PostgreSQL, and ODBC statement handles
Next
From: Wei Shan
Date:
Subject: [INTERFACES] Questions on Cursors in PostgreSQL