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