Re: BUG #4274: uuid returns duplicate values

Hi Eric-san.

Thank you for an early check. !
I understand that many users think are same with you.
more gratitude:-)

Regards,
Hiroshi Saito

----- Original Message -----
From: "Eric P. Melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com>

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