| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Reza Taheri <rtaheri(at)vmware(dot)com> |
| Cc: | "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL, and ODBC statement handles |
| Date: | 2017-05-04 04:12:49 |
| Message-ID: | 18800.1493871169@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
Reza Taheri <rtaheri(at)vmware(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wei Shan | 2017-06-27 17:07:57 | Questions on Cursors in PostgreSQL |
| Previous Message | Reza Taheri | 2017-05-03 23:41:33 | PostgreSQL, and ODBC statement handles |