Re: Primary keys and speed

Поиск
Список
Период
Сортировка
От Rob Brown-Bayliss
Тема Re: Primary keys and speed
Дата
Msg-id 1000084400.29120.0.camel@ZOOstation.cc
обсуждение исходный текст
Ответ на Primary keys and speed  (Rob Brown-Bayliss <on_the_net@clear.net.nz>)
Список pgsql-general
Hi, I have not yet seen an answer to the following, can I assume it's
not a problem?

On Thu, 2001-09-06 at 19:58, Rob Brown-Bayliss wrote:
>
> 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 по дате отправления:

Предыдущее
От: Mike Withers
Дата:
Сообщение: User Input - Multiple Parameters
Следующее
От: "Joe Conway"
Дата:
Сообщение: Re: Primary keys and speed