Re: uuid, COMB uuid, distributed farms

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: uuid, COMB uuid, distributed farms
Дата
Msg-id 764796.51323.qm@web82103.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: uuid, COMB uuid, distributed farms  (Dennis Gearon <gearond@sbcglobal.net>)
Список pgsql-general
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?


В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: uuid, COMB uuid, distributed farms
Следующее
От: bricklen
Дата:
Сообщение: Re: ERROR: could not open relation base/2757655/6930168: No such file or directory -- during warm standby setup