X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 7C330921DD8 for ; Fri, 30 May 2003 13:03:49 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 50167-03 for ; Fri, 30 May 2003 13:03:49 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by developer.postgresql.org (Postfix) with ESMTP id 9D691921BD9 for ; Fri, 30 May 2003 13:03:48 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3079050; Fri, 30 May 2003 10:03:53 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Andrew Sullivan , pgsql-performance@postgresql.org Subject: Re: Table Relationships Date: Fri, 30 May 2003 10:03:19 -0700 User-Agent: KMail/1.4.3 References: <200305300906.43044.josh@agliodbs.com> <20030530163900.GF18140@libertyrms.info> In-Reply-To: <20030530163900.GF18140@libertyrms.info> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305301003.19829.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/283 X-Sequence-Number: 2062 Andrew, > Are you sure you want to say it that strongly? After all, if you > have a data set which needs always to be returned in the same static > format, why not just denormalise it? It's sure faster that way in > every system I've ever encountered. > > It's only when you actually have relations to cope with that it > ceases to be an advantage. So, as usual, it depends on what you're > trying to do. Yeah, I suppose so ... if all they're doing is reporting on a static set of data which is not transactional ... sure. If it's a disposable, limited-time-use application. However, I have yet to see in my professional experience any application that was really this way and stayed this way once it was in use ... relations have a way of creeping in, and planning for them is less messy than refactoring. -- Josh Berkus Aglio Database Solutions San Francisco