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

Re: BUG #4274: uuid returns duplicate values

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Eric P(dot) Melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com>,"Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: "Nicolas ANTONINI" <nicolas(dot)antonini(at)mnm-consulting(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4274: uuid returns duplicate values
Date: 2008-08-23 17:30:23
Message-ID: 012d01c90545$ec8b6350$0c01a8c0@IBMC9A0F63B40D (view raw or flat)
Thread:
Lists: pgsql-bugs
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 


In response to

pgsql-bugs by date

Next:From: Richard EvansDate: 2008-08-23 20:46:54
Subject: Re: BUG #3818: Cross compilation problems
Previous:From: Eric P. MelbardisDate: 2008-08-23 17:07:58
Subject: Re: BUG #4274: uuid returns duplicate values

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