From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: FW: Surrogate keys (Was: enums) |
Date: | 2006-01-19 03:13:10 |
Message-ID: | 200601181913.11349.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Dann,
> The primary key should be immutable, meaning that its value should not be
> changed during the course of normal operations of the database.
Why? I don't find this statement to be self-evident. Why would we have ON
UPDATE CASCADE if keys didn't change sometimes?
> At any rate, the use of natural keys is a mistake made by people who have
> never had to deal with very large database systems.
Oh, I guess I'm dumb then. The biggest database system I ever had to deal
with was merely 5 TB ...
Anyway, my opinion on this, in detail, will be on the ITToolBox blog. You can
argue with me there.
--
Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | CSN | 2006-01-19 03:46:14 | \s tail? |
Previous Message | Bruce Momjian | 2006-01-19 03:11:26 | Re: [HACKERS] No heap lookups on index |
From | Date | Subject | |
---|---|---|---|
Next Message | uwcssa | 2006-01-19 03:35:48 | suppress output for benchmarking |
Previous Message | Bruce Momjian | 2006-01-19 03:11:26 | Re: [HACKERS] No heap lookups on index |