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 по дате отправления: