In my younger days I denormalized a database for performance reasons and have been paid for it dearly with increased maintenance costs. Adding enhanced capabilities and new functionality will render denormalization worse than useless quickly. --Rick
Frank Wiles
<[EMAIL PROTECTED]> To: Josh
Berkus <[email protected]>
Sent by: cc:
[email protected]
[EMAIL PROTECTED] Subject: Re: [PERFORM] Low
Performance for big hospital server ..
tgresql.org
01/06/2005 12:12 PM
On Thu, 6 Jan 2005 09:06:55 -0800
Josh Berkus <[email protected]> wrote:
> I can't tell you how many times I've seen this sort of thing. And
> the developers always tell me "Well, we denormalized for performance
> reasons ... "
Now that's rich. I don't think I've ever seen a database perform
worse after it was normalized. In fact, I can't even think of a
situation where it could!
---------------------------------
Frank Wiles <[EMAIL PROTECTED]>
http://www.wiles.org
---------------------------------
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
