BUG #9373: UUID, UUID-OSSP extension, and ODBC issues

From: consolity(at)outlook(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9373: UUID, UUID-OSSP extension, and ODBC issues
Date: 2014-02-27 20:12:45
Message-ID: 20140227201245.29537.15626@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9373
Logged by: Jeremy Thornton
Email address: consolity(at)outlook(dot)com
PostgreSQL version: 9.3.3
Operating system: Windows 8.1 Pro
Description:

In using pgsqlODBC 09.03.0200 or any version prior that we have tested we
seem to be having a performance decrease to only 625 inserts per second when
using UUID as the primary key and using the UUID-OSSP to generate the
default value of uuid_generate_v1() whereas if we generate the UUID client
side for the primary key and send it with the values in the insert
transaction we can increase it to 1500 inserts per second bypassing the
UUID-OSSP extension. This is consistent and repeatable. The only change
being made is Postgres generating the UUID using the extension or us passing
the value in the insert statement. If Postgres generates it internally while
inserting using PgAdmin then it can generate at near 2000 inserts per second
so uuid-ossp shouldn't be the problem since it can keep up, but when used
over default settings in ODBC it is 2/3 slower. The data being tested is the
same in all cases. I am using a default System DSN on Windows 8.1 Pro (no
special settings). Is this a bug or a settings adjustment that needs to be
made?

Browse pgsql-bugs by date

  From Date Subject
Next Message shivshi 2014-02-27 21:43:20 Re: PostgreSQL 6.2.5 Visual Studio Build does not pass the regression tests.
Previous Message Jeremy Thornton 2014-02-27 20:10:40 UUID, UUID-OSSP extension, and ODBC issue