From: | "Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> |
---|---|
To: | "Douglas McNaught" <doug(at)mcnaught(dot)org> |
Cc: | "John Meyer" <john(dot)l(dot)meyer(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: counting query |
Date: | 2007-01-28 17:30:53 |
Message-ID: | 73427AD314CC364C8DF0FFF9C4D693FF5529@nehemiah.joris2k.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>-----Original Message-----
>From: Douglas McNaught [mailto:doug(at)mcnaught(dot)org]
>Sent: zondag 28 januari 2007 16:29
>To: Joris Dobbelsteen
>Cc: John Meyer; pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] counting query
>
>"Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> writes:
>
>> What would have been better without surrogate keys all-over:
>> * Easier to write complex queries with much fewer tables to
>be queried.
>> * Much faster query performance, as fewer tables need to be
>referenced.
>> * Better integrity enforcement with simple foreign key constraints.
>
>Not this debeta again. ;)
>
>Surrugate vs natural keys shouldn't make a difference in how
>many yables you have--they depends on the degree of
>normalization. Sounds like you denormalized your database and
>happened to eliminate surrogate keys at the same time. Using
>that to say "surrogate keys are bad" is kind of misleading.
I have perhaps formulated it quite extreme. It was not intended to take
such a extreme stance. I appologize if it will lead to such a
discussion. I'll try to do it a bit more careful next time.
My point is only, be careful with surrogate keys and try not the use
them for everything. In my sole opinion I see them getting used too
much. But then again, what is good and wrong will always be subjective.
So perhaps <quote>What would have been better without surrogate keys
all-over<quote> should have been "My database where I extremely overdid
it with surrogate keys".
Lets leave it to this.
- Joris
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas McNaught | 2007-01-28 17:33:45 | Re: counting query |
Previous Message | Tom Lane | 2007-01-28 17:08:11 | Re: "explain analyse" much slower than actual query |