Re: Low Performance for big hospital server ..

Поиск
Список
Период
Сортировка
От Yann Michel
Тема Re: Low Performance for big hospital server ..
Дата
Msg-id 20050106190957.GA15890@zong.spline.inf.fu-berlin.de
обсуждение исходный текст
Ответ на Re: Low Performance for big hospital server ..  (Rod Taylor <pg@rbt.ca>)
Список 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 по дате отправления:

Предыдущее
От: Richard_D_Levine@raytheon.com
Дата:
Сообщение: Re: Low Performance for big hospital server ..
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Low Performance for big hospital server ..