Re: Low Performance for big hospital server ..

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
<frank(at)wiles(dot)org> To: Josh Berkus <josh(at)agliodbs(dot)com>
Sent by: cc: pgsql-performance(at)postgresql(dot)org
pgsql-performance-owner(at)pos 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 <josh(at)agliodbs(dot)com> 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 <frank(at)wiles(dot)org>
http://www.wiles.org
---------------------------------

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly