[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Using PK value as a String
From:       Moritz Onken <onken () houseofdesign ! de>
Date:       2008-08-12 14:17:58
Message-ID: 1343069D-263F-4D99-BF7E-269C8F0E7F1F () houseofdesign ! de
[Download RAW message or body]

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.

moritz

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]