From: | Rob Brown-Bayliss <on_the_net(at)clear(dot)net(dot)nz> |
---|---|
To: | Rob Brown-Bayliss <on_the_net(at)clear(dot)net(dot)nz> |
Cc: | PostgreSQL General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Primary keys and speed |
Date: | 2001-09-10 01:13:20 |
Message-ID: | 1000084400.29120.0.camel@ZOOstation.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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======---
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Withers | 2001-09-10 01:36:27 | User Input - Multiple Parameters |
Previous Message | Justin Clift | 2001-09-09 23:46:38 | Re: Idea: jobs.postgresql.org |