| From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
|---|---|
| To: | Jeremy Thornton <consolity(at)outlook(dot)com> |
| Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: UUID, UUID-OSSP extension, and ODBC issue |
| Date: | 2014-02-28 17:54:13 |
| Message-ID: | 5310CD45.9010806@vmware.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-odbc |
On 02/28/2014 07:49 PM, Jeremy Thornton wrote:
> Thanks for the info Heikki. However, my concern is the fact that the
> same insert when ran inside PgAdmin executes at 2000 inserts per
> second whereas through ODBC it is at 625 inserts per second. It seems
> that if uuid_generate_v1() was the only bottleneck it would occur
> inside PgAdmin. Same information, same uuid_generate_v1() default.
> Any thoughts on why the performance difference between the two?
Oh, I misunderstood the issue then. How exactly are you executing the
inserts? Do you run all the inserts as a single transaction (that's
faster than separate transactions)? If you can create a self-contained
ODBC test program and post it to the list, I can take a closer look...
- Heikki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Thornton | 2014-02-28 20:19:39 | Re: UUID, UUID-OSSP extension, and ODBC issue |
| Previous Message | Jeremy Thornton | 2014-02-28 17:49:47 | Re: UUID, UUID-OSSP extension, and ODBC issue |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Thornton | 2014-02-28 20:19:39 | Re: UUID, UUID-OSSP extension, and ODBC issue |
| Previous Message | Jeremy Thornton | 2014-02-28 17:49:47 | Re: UUID, UUID-OSSP extension, and ODBC issue |