Primary keys and speed

Поиск
Список
Период
Сортировка
От Rob Brown-Bayliss
Тема Primary keys and speed
Дата
Msg-id 999763135.4949.3.camel@ZOOstation.cc
обсуждение исходный текст
Ответы Re: Primary keys and speed
Список pgsql-general
Hello.

I am looking at useing uuid's as primary keys rather than a normal
sequence of numbers.

The uuids are long text strings like so:

7559e648-a29c-11d5-952f-00c026a18838

The reason for useing them is that it's almost gaurenteed that
imported data from another site is going to have a unique identifier.

But I was wondering if this will impact on the speed of the database.

In the long run the application does not need to be blindingly fast as 99%
of the time it is waiting on human interaction.

Any ideas?

--

  Rob Brown-Bayliss
 ---======o======---

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

Предыдущее
От: "Colin 't Hart"
Дата:
Сообщение: Re: MySQL's (false?) claims... (was: Re: PL/java?)
Следующее
От: Eric Kolve
Дата:
Сообщение: getting inherited table name