Skip site navigation (1) Skip section navigation (2)

Re: BUG #4274: uuid returns duplicate values

From: "Eric P(dot) Melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com>
To: Hiroshi Saito <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>, Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Nicolas ANTONINI <nicolas(dot)antonini(at)mnm-consulting(dot)com>,"pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4274: uuid returns duplicate values
Date: 2008-08-23 17:07:58
Message-ID: D4420863DC4F1D4F80104C3882FA9BF224F350151B@EXVMBX017-10.exch017.msoutlookonline.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi

Testing on my home system, looking good... will try on my office system Monday.

Note:
        I am assuming that the uuid will mostly be used as a primary key on records that will exist in replicated databases to guarantee uniqueness. The problem that is see with the current uuid functions for this purpose is that the generated uuid is very random causing great performance issues with the index; at least when using oracle and ms sql server, did not try with postgres, but must be similar. Usually inserting random data into an index of any kind is a worst case stress test. Hence the older style of uuid, based on mac addresses and time tend to generate more sequential uuid's, at least when inserting a bunch of records at once.

In other words it would be nice to have the old fashioned style of uuid's.

Regards

Eric


-----Original Message-----
From: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp]
Sent: Saturday, August 23, 2008 8:26 AM
To: Eric P. Melbardis; Bruce Momjian
Cc: Nicolas ANTONINI; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values

Hi Eric-san.

Done! please check it.
http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080824.zip
I checked by the following machine.
-- Disktop(Windows-XP SP2)
Pentium(R) 4 CPU 2.6GHz
Memory 2GB
-- Notebook(Windows-XP SP2)
Pentium III CPU 495 MHz
Memory 256MB
--

Thanks.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>


> Ooops, Please wait for this.
>
>> Please try this.(The date of a binary is 7/8)
>> http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080823.zip
>> I will arrange thoroughly again.
>
> Anyhow, I have only now stale development environment.
> The time of a check is still required. thanks.
>
> Regards,
> Hiroshi Saito
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

In response to

Responses

pgsql-bugs by date

Next:From: Hiroshi SaitoDate: 2008-08-23 17:30:23
Subject: Re: BUG #4274: uuid returns duplicate values
Previous:From: Hiroshi SaitoDate: 2008-08-23 15:25:45
Subject: Re: BUG #4274: uuid returns duplicate values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group