Re: Low Performance for big hospital server .. - Mailing list pgsql-performance

From Dave Cramer
Subject Re: Low Performance for big hospital server ..
Date
Msg-id 41DD76E5.1090806@fastcrypt.com
Whole thread Raw
In response to Re: Low Performance for big hospital server ..  (Frank Wiles <frank@wiles.org>)
Responses Re: Low Performance for big hospital server ..
List pgsql-performance
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@agliodbs.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@wiles.org>
>   http://www.wiles.org
> ---------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>
>
>

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


pgsql-performance by date:

Previous
From: Frank Wiles
Date:
Subject: Re: Low Performance for big hospital server ..
Next
From: Josh Berkus
Date:
Subject: Re: Denormalization WAS: Low Performance for big hospital server ..