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

From Yann Michel
Subject Re: Low Performance for big hospital server ..
Date
Msg-id 20050106190957.GA15890@zong.spline.inf.fu-berlin.de
Whole thread Raw
In response to Re: Low Performance for big hospital server ..  (Rod Taylor <pg@rbt.ca>)
List pgsql-performance
Hi

On Thu, Jan 06, 2005 at 12:51:14PM -0500, Rod Taylor wrote:
> On Thu, 2005-01-06 at 12:35 -0500, Dave Cramer wrote:
> > Reading can be worse for a normalized db, which is likely what the
> > developers were concerned about.
>
> To a point. Once you have enough data that you start running out of
> space in memory then normalization starts to rapidly gain ground again
> because it's often smaller in size and won't hit the disk as much.

Well, in datawarehousing applications you'll often denormalize your
entities due to most of the time the access method is a (more or less)
simple select.

Regards,
Yann

pgsql-performance by date:

Previous
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: Low Performance for big hospital server ..
Next
From: Greg Stark
Date:
Subject: Re: Low Performance for big hospital server ..