Re: Using PK value as a String

From: Moritz Onken <onken(at)houseofdesign(dot)de>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Using PK value as a String
Date: 2008-08-12 14:17:58
Message-ID: 1343069D-263F-4D99-BF7E-269C8F0E7F1F@houseofdesign.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2008-08-12 14:29:17 Re: Using PK value as a String
Previous Message Mark Mielke 2008-08-12 14:11:50 Re: Using PK value as a String