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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2008-08-23 17:30:23 | Re: BUG #4274: uuid returns duplicate values |
Previous Message | Hiroshi Saito | 2008-08-23 15:25:45 | Re: BUG #4274: uuid returns duplicate values |