Re: Primary keys and speed

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======---

In response to

Responses

Browse pgsql-general by date

  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