| 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: | Whole Thread | Raw Message | 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 |