Re: Low Performance for big hospital server ..

Reading can be worse for a normalized db, which is likely what the
developers were concerned about.

One always have to be careful to measure the right thing.

Dave

Frank Wiles wrote:

>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
>
>
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561