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

From Moritz Onken
Subject Re: Using PK value as a String
Date
Msg-id 1343069D-263F-4D99-BF7E-269C8F0E7F1F@houseofdesign.de
Whole thread Raw
In response to Re: Using PK value as a String  (Mathias Stjernström <mathias@globalinn.com>)
Responses Re: Using PK value as a String  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Using PK value as a String
Next
From: Bill Moran
Date:
Subject: Re: Using PK value as a String