X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8C3A93A4562 for ; Thu, 6 Jan 2005 17:11:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20304-09 for ; Thu, 6 Jan 2005 17:11:02 +0000 (GMT) Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by svr1.postgresql.org (Postfix) with ESMTP id B94B13A4590 for ; Thu, 6 Jan 2005 17:10:55 +0000 (GMT) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id j06HBWws006757; Thu, 6 Jan 2005 11:11:32 -0600 Date: Thu, 6 Jan 2005 11:12:07 -0600 From: Frank Wiles To: Josh Berkus Cc: pgsql-performance@postgresql.org Subject: Re: Low Performance for big hospital server .. Message-Id: <20050106111207.52e39d04.frank@wiles.org> In-Reply-To: <200501060906.55832.josh@agliodbs.com> References: <1104831107.41da6283add0c@webmail.moph.go.th> <1104939342.41dc094ecb1cf@webmail.moph.go.th> <758d5e7f050106041510f07dc5@mail.gmail.com> <200501060906.55832.josh@agliodbs.com> X-Mailer: Sylpheed version 0.9.10 (GTK+ 1.2.10; i386-redhat-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/69 X-Sequence-Number: 9759 On Thu, 6 Jan 2005 09:06:55 -0800 Josh Berkus 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 http://www.wiles.org ---------------------------------