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@xxxxxxxxx> To: Dennis Gearon <gearond@xxxxxxxxxxxxx> Sent: Sun, January 2, 2011 8:49:13 PM Subject: Re: uuid, COMB uuid, distributed farms On Sun, Jan 2, 2011 at 8:26 PM, Dennis Gearon <gearond@xxxxxxxxxxxxx> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
