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