DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=et1dSUXjAWMsCgbVEl4zlD0DU5ADDDYF9T+PPl0QzkY5Wr492wov7W9taK+BO6aS6PMiYZcOPQlzplR2l6K4z6do9SvQw5asxX09aymuAdhdBiCQxAPtH2qxSdT9DBmx6Uiv2iuGlvGEaydu4TaZ7phOBMO9KG2RYk+vkniOm6w=;
Message-ID: <764796.51323.qm@web82103.mail.mud.yahoo.com>
References: <945290.45189.qm@web82104.mail.mud.yahoo.com>
	<AANLkTikXCNuTw9hGFpghMBkC0dfbVP51XhZuK3EMWVPt@mail.gmail.com>
Date: Sun, 2 Jan 2011 20:56:28 -0800 (PST)
From: Dennis Gearon <gearond@sbcglobal.net>
Subject: Re: uuid, COMB uuid, distributed farms
To: pgsql-general@postgresql.org
In-Reply-To: <AANLkTikXCNuTw9hGFpghMBkC0dfbVP51XhZuK3EMWVPt@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Good catch! The article is:=0A=0Ahttp://www.informit.com/articles/printerfr=
iendly.aspx?p=3D25862=0A=0A Dennis Gearon=0A=0A=0ASignature Warning=0A-----=
-----------=0AIt is always a good idea to learn from your own mistakes. It =
is usually a better =0Aidea to learn from others=E2=80=99 mistakes, so you =
do not have to make them yourself. =0Afrom 'http://blogs.techrepublic.com.c=
om/security/?p=3D4501&tag=3Dnl.e036'=0A=0A=0AEARTH has a Right To Life,=0Ao=
therwise we all die.=0A=0A=0A=0A----- Original Message ----=0AFrom: brickle=
n <bricklen@gmail.com>=0ATo: Dennis Gearon <gearond@sbcglobal.net>=0ASent: =
Sun, January 2, 2011 8:49:13 PM=0ASubject: Re: [GENERAL] uuid, COMB uuid, d=
istributed farms=0A=0AOn Sun, Jan 2, 2011 at 8:26 PM, Dennis Gearon <gearon=
d@sbcglobal.net> wrote:=0A> On the tests in this article, doing large amoun=
ts of consecutive inserts,=0A> generating new UUIDs, and having the indexes=
 getting updated caused a 30=0A> (THIRTY) times increase in time to do inse=
rts. So he came up with a function=0A> that caused the lowest characters of=
 the UUIDs to change slowly according to=0A> time in microseconds. This red=
uced the time to using UUIDs for PKs for inserts=0A> and joins BOTH by only=
 10% relative to SEQUENCES and their integer primary =0A>keys.=0A=0AI think=
 you forgot to link to the article?=0A