Re: Using PK value as a String - Mailing list pgsql-performance

From Bill Moran
Subject Re: Using PK value as a String
Date
Msg-id 20080812110416.8e0d6e1c.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: Using PK value as a String  (Moritz Onken <onken@houseofdesign.de>)
Responses Re: Using PK value as a String
List pgsql-performance
In response to Moritz Onken <onken@houseofdesign.de>:

> We chose UUID as PK because there is still some information in an
> integer key.
> You can see if a user has registered before someone else (user1.id <
> user2.id)
> or you can see how many new users registered in a specific period of
> time
> (compare the id of the newest user to the id a week ago). This is
> information
> which is in some cases critical.

So you're accidentally storing critical information in magic values
instead of storing it explicitly?

Good luck with that.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

pgsql-performance by date:

Previous
From: Moritz Onken
Date:
Subject: Re: Using PK value as a String
Next
From: Moritz Onken
Date:
Subject: Re: Using PK value as a String