From: Dennis Gearon <gearond@sbcglobal.net>
To: pgsql-general@postgresql.org
Subject: Re: uuid, COMB uuid, distributed farms
Date: Sun, 2 Jan 2011 20:56:28 -0800 (PST)
Message-ID: <764796.51323.qm@web82103.mail.mud.yahoo.com> (raw)
In-Reply-To: <AANLkTikXCNuTw9hGFpghMBkC0dfbVP51XhZuK3EMWVPt@mail.gmail.com>
References: <945290.45189.qm@web82104.mail.mud.yahoo.com>
<AANLkTikXCNuTw9hGFpghMBkC0dfbVP51XhZuK3EMWVPt@mail.gmail.com>
Good catch! The article is:
http://www.informit.com/articles/printerfriendly.aspx?p=25862
Dennis Gearon
Signature Warning
----------------
It is always a good idea to learn from your own mistakes. It is usually a better
idea to learn from others’ mistakes, so you do not have to make them yourself.
from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036';
EARTH has a Right To Life,
otherwise we all die.
----- Original Message ----
From: bricklen <bricklen@gmail.com>
To: Dennis Gearon <gearond@sbcglobal.net>
Sent: Sun, January 2, 2011 8:49:13 PM
Subject: Re: [GENERAL] uuid, COMB uuid, distributed farms
On Sun, Jan 2, 2011 at 8:26 PM, Dennis Gearon <gearond@sbcglobal.net> wrote:
> On the tests in this article, doing large amounts of consecutive inserts,
> generating new UUIDs, and having the indexes getting updated caused a 30
> (THIRTY) times increase in time to do inserts. So he came up with a function
> that caused the lowest characters of the UUIDs to change slowly according to
> time in microseconds. This reduced the time to using UUIDs for PKs for inserts
> and joins BOTH by only 10% relative to SEQUENCES and their integer primary
>keys.
I think you forgot to link to the article?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: gearond@sbcglobal.net
Subject: Re: uuid, COMB uuid, distributed farms
In-Reply-To: <764796.51323.qm@web82103.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox