From: Richard_D_Levine@raytheon.com
To: Frank Wiles <frank@wiles.org>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Cc: pgsql-performance-owner@postgresql.org
Subject: Re: Low Performance for big hospital server ..
Date: Thu, 6 Jan 2005 13:33:00 -0500
Message-ID: <OFFAF4E49E.8472B1FE-ON05256F81.006575F6@ftw.us.ray.com> (raw)
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@wiles.org> To: Josh Berkus <josh@agliodbs.com>
Sent by: cc: pgsql-performance@postgresql.org
pgsql-performance-owner@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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Richard_D_Levine@raytheon.com, frank@wiles.org, josh@agliodbs.com, pgsql-performance-owner@postgresql.org
Subject: Re: Low Performance for big hospital server ..
In-Reply-To: <OFFAF4E49E.8472B1FE-ON05256F81.006575F6@ftw.us.ray.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox