Primary keys and speed - Mailing list pgsql-general

From Rob Brown-Bayliss
Subject Primary keys and speed
Date
Msg-id 999763135.4949.3.camel@ZOOstation.cc
Whole thread Raw
Responses Re: Primary keys and speed
List pgsql-general
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 by date:

Previous
From: "Colin 't Hart"
Date:
Subject: Re: MySQL's (false?) claims... (was: Re: PL/java?)
Next
From: Eric Kolve
Date:
Subject: getting inherited table name