| From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
|---|---|
| To: | "Vilches, Alejandro" <alejandro(dot)vilches(at)intel(dot)com>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: odbc vs. libpq performance |
| Date: | 2015-04-16 07:14:54 |
| Message-ID: | 552F616E.3080508@iki.fi |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
On 04/16/2015 03:30 AM, Vilches, Alejandro wrote:
> I have a simple program that inserts data into a single table (see details below). When I have the program connect to the DB via ODBC, performance is significantly slower compared to when I have it connect via libpq. I was able to achieve ~1000 transactions per second using libpq, but only ~4 transactions per second using the ODBC driver.
I'd suggest setting log_min_duration_statement = 0 in the server's
config file. Then repeat the test and look at the log file to see where
the time is spent. If that gives no clue, I'm happy to take a look, if
you can reproduce it with a small test program and post it to a list.
- Heikki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2015-04-16 07:16:36 | Re: PGSQL ODBC driver crash in CC_get_current_schema |
| Previous Message | Vilches, Alejandro | 2015-04-16 00:30:22 | Re: odbc vs. libpq performance |