pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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






view thread (38+ messages)  latest in thread

Message-ID: <OFFAF4E49E.8472B1FE-ON05256F81.006575F6@ftw.us.ray.com>
Permalink:  ../OFFAF4E49E.8472B1FE-ON05256F81.006575F6@ftw.us.ray.com/
Also on:    postgresql.org/message-id/OFFAF4E49E.8472B1FE-ON05256F81.006575F6@ftw.us.ray.com

 · 

reply

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